Order by Weekday in Table and Form

[kazaccess]

I have a column in my table for day of the week (Monday, Tuesday, etc.). What can I enter in the "Order By" table-property to order the records by their chronological weekdays? Additionally, is there a similar type of action I can perform within a related form?

Thank you

[orange]

check this and look at weekday, weekdayname

[A S MANN]

Use
Where date is Date Field in dd/mm/yyyy format(Or any other Format)
Actual Day: Weekday([Date],1)
This will give Actual Day eg Monday =1, Tuesday =2 etc
Than sort by Actual Day

[kazaccess]

Great. Exactly what I'm looking for. Thanks!