Sorting days of week in query and report access 2010

[anlimah]

I have a text field in my table called [week day] Monday thru Friday groups transpire in my business. I would like to sort the days of the week in order and not alphabetically. I respectfully request step by step information. I am pulling my hair out. Please assist. Thanks

[June7]

Options:

1. calculate the weekday number in a query and use that calculated field for sorting
Switch([week day]="Monday",1, [week day]="Tuesday",2, [week day]="Wednesday",3 [week day]="Thursday",4, [week day]="Friday",5, [week day]="Saturday",6 , [week day]="Sunday",7)

2. store weekday number instead of weekday name and then calculate name when needed:
Choose([week day], 1, "Monday", 2, "Tuesday", 3, "Wednesday", 4, "Thursday", 5, "Friday", 6, "Saturday", 7, "Sunday")

3. regardless of which is saved, have a lookup table and include it in query used as report RecordSource

[anlimah]

Where in query do i type expression you provided. What field name do i use for calculated field. Can you list each step for "dummie" sorry

[June7]

Expression is typed on the Field row of query builder.

If not specified, Access will default field name to something like Expr1. Use whatever you want, maybe DayName or DayNumber.

Access Help has more guidelines on building queries and using expressions.

[anlimah]

thank you jun 7. was able to get the sorting to my liking. I had to finagle a bit, but ultimately your suggestion worked.