By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 1,915 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 IT Pros & Developers. It's quick & easy.

Access query

P: n/a
Does anyone know how to sort the days of the week in order, Monday Tuesday
etc. As entered as text they would normally be sorted alphabetically i.e.
Friday, Monday, Saturday, Sunday
Rog
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Have you tried adding another field and allocating a number to it depending
on the entry for the day and then sorting that field numerically. If you are
selecting the days from a combo box you could add another column for the
numbers.

"Roger Spratt" <is****@ntlworld.com> wrote in message
news:kg****************@newsfe5-gui.ntli.net...
Does anyone know how to sort the days of the week in order, Monday Tuesday
etc. As entered as text they would normally be sorted alphabetically
i.e. Friday, Monday, Saturday, Sunday
Rog

Nov 13 '05 #2

P: n/a
Make a new column in the query and enter a new field along the lines of DOW:
weekday([datefield]) where [datefield] has the date value. Review help on
weekday for further options

hth,
tim mills-groninger

"Roger Spratt" <is****@ntlworld.com> wrote in message
news:kg****************@newsfe5-gui.ntli.net...
Does anyone know how to sort the days of the week in order, Monday Tuesday
etc. As entered as text they would normally be sorted alphabetically
i.e. Friday, Monday, Saturday, Sunday
Rog

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.