Query - Days of week

[bjohran]

Do you know how to sort in a query the days in the week (Mon-Sat), so that the query will sort Mon,Tues,Wed,Thur,Etc instead of sorting ascending order. I don't know if you set this up in the actual table or what. Right know the table name of (day) is a text field.

 

[evalesthy]

Two thoughts occur to me. First, you could use the 'Weekday Function' (see access help) if a sort of Sunday (=1) to Saturday (=7) is OK. This won't help if you want to start sort on Monday (=2). Second, you could create a separate table with two fields 'WeekdayName' and 'SortOrder' and assign Monday a 1, Tuesday a 2, etc. and then use this value in your query. Hope this gives you some ideas.