how do I have the day of week return in a query in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm trying to build a query that includes a date field, and which shows the
date and also calculates a separate field which will show the day of the week
for the date in the date field. I will later use this information to show
occurances by day of the week.

Here is what I have been trying, but which only gives me error messages...

DayofWeek: weekdayname("dddd",[Date]).

Any help would be appreciated!

Gordon
 
Back
Top