How do I change the sort order of days of the week?

J

jtracy

I am planning a conference and want the report I created to list attendees by
the day of the week they are attending and in order of the days of the week
(Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday) and not
(Thursday, Tuesday, Wednesday).
 
R

Rick Brandt

jtracy said:
I am planning a conference and want the report I created to list
attendees by the day of the week they are attending and in order of
the days of the week (Sunday, Monday, Tuesday, Wednesday, Thursday,
Friday, Saturday) and not (Thursday, Tuesday, Wednesday).

Include an additional field that has the weekday number value and sort on
that.
 
D

Douglas J Steele

Just to be perfectly clear, Rick isn't suggesting adding a numeric weekday
field to your table. There's a built-in Weekday function that you can add to
your query.
 

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

Top