How do I sort by day of week?

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

Guest

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!
 
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.
 
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...
 
Back
Top