in vba for access how do i get the day of the week for a date field?

[Daniel]

in vba for access how do i get the day of the week for a date field?

 

[Dave Peterson]

You mean Monday, Tuesday,...

Dim myDate As Date
myDate = DateSerial(2005, 12, 25)
MsgBox Format(myDate, "dddd")

or the day portion of the date?

Dim myDate As Date
myDate = DateSerial(2005, 12, 25)
MsgBox Day(myDate)