How do I sort by day of week?

M

Meg

I have a query that displays sales by day of week, however it only allows me
to display the days in alphabetical order (Friday, Monday, Thursday...), as
opposed to chronological order (Monday, Tuesday, Wednesday.) How can I sort
chronologically? Thanks!
 
M

Marshall Barton

Meg said:
I have a query that displays sales by day of week, however it only allows me
to display the days in alphabetical order (Friday, Monday, Thursday...), as
opposed to chronological order (Monday, Tuesday, Wednesday.) How can I sort
chronologically?
Click to expand...

Create a calculated field in a blank column of the query
design grid with the expression WeekDay([the date field]).
Uncheck the Show Box and select Ascending in the Sort row.
 
M

Meg

Worked great! Thanks so much.

Marshall Barton said:
Meg said:
I have a query that displays sales by day of week, however it only allows me
to display the days in alphabetical order (Friday, Monday, Thursday...), as
opposed to chronological order (Monday, Tuesday, Wednesday.) How can I sort
chronologically?
Click to expand...

Create a calculated field in a blank column of the query
design grid with the expression WeekDay([the date field]).
Uncheck the Show Box and select Ascending in the Sort row.
Click to expand...
 
Top