How do I sort by day of week?

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!
 
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.
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Week and days query 8
Week, monthly, quarterly 2
Filter for Day of the Week 4
Multiple IIF Statement... 4
Countif w/semicolon separated values AND Filter 1
Query from day of week 3
Countif w/semicolon separated values 4
How in Access do I use Date()+2 missing weeknds (e.g Thu+2 = Mon) 2

Top