Access 2010 - Day of the Week

[carrietm]

We would like to analize which days of the week are busier than others (Mon, Tues, Wed...) Is there an expression that I can use to format a date and time field for the day of the week? Something like what is being used to format the month below?

OrderMonth: Format([ORDER DATE_TIME],"mmm")

[HansV]

You can replace "mmm" with:

"ddd" for the abbreviated name of the day (Sun - Sat), or
"dddd" for the full name of the day (Sunday - Saturday)

Alternatively, Weekday([ORDER DATE_TIME]) will return a number corresponding to the day of the week: 1 for Sunday, 2 for Monday, etc.

[carrietm]

This is such a big help - Thank you!