How to sort Day of week from Monday to Saturday

[ultra5219]

Hi guys
does anyone knows how to sort days of week from Monday to saturday.
im currently doing database of school timetable. im trying to display timetable report using Query by entering department ID then it will display school timetable from monday to saturday. But the problem is the report wont sort properly. it shows Monday Saturday Thursday.. which it wont sort properly.

any clues?
im trying to follow from this using expression on query but still fail to solve it.. can anyone teach me steps to do it?
Reference link : http://www.ehow.com/how_2125018_use-...cess-2007.html
Thanks..


Attachment 11220

[alansidman]

Add a field to your query. Type this expression in it

DayOfWeek: Weekday([Day])

This should return the numerical value of the day of the week. Use this field to sort your data. You can hide the field by unchecking the check box if it does not need to be seen.

BTW: Day is a reserved term in Access and should not be used as a field name. This is also true for the term Time.

Here is a listing of reserved terms.

http://office.microsoft.com/en-us/ac...010030643.aspx

[ultra5219]

Add a field to your query. Type this expression in it

DayOfWeek: Weekday([Day])

This should return the numerical value of the day of the week. Use this field to sort your data. You can hide the field by unchecking the check box if it does not need to be seen.

BTW: Day is a reserved term in Access and should not be used as a field name. This is also true for the term Time.

Here is a listing of reserved terms.

http://office.microsoft.com/en-us/ac...010030643.aspx

i try to type on query but it give me some error?? any ideas? did i do wrong expression command?
sorry im still quite new on Access.. currently im using Access 2007.
Attachment 11223

[alansidman]

You need to put it in a new column (field) not in the criteria.

Look at this tutorial on how to do that

http://office.microsoft.com/en-us/ac...005188023.aspx