Have query Display Days in Order

[jo15765]

I have a query that displays the days of the week. Is there a way to have this query display the days of the week in order? I.E. Monday, Tuesday, Wednesday, Thursday, Friday --- I looked at the input mask but I didn't see that as an option.

[alansidman]

Are you able to tweak your query to give you an actual date. If so, then you could use the weekday function to sort

http://www.techonthenet.com/access/f...te/weekday.php

Alan

[jo15765]

That looks close to what I am trying to accomplish. I actually have the days of the week as a field in my table, I would prefer (if possible) to return the name of the day of the week as opposed to a numeric value. Again that is if possible.

[orange]

Try this example
http://www.techonthenet.com/access/f...eekdayname.php