Access query

[Roger Spratt]

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

[Mick]

Re: Access query

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" <istana@ntlworl d.com> wrote in message
news:kgS_d.1164 $m63.882@newsfe 5-gui.ntli.net...[color=blue]
> 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
>[/color]

[Tim Mills-Groninger]

Re: Access query

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" <istana@ntlworl d.com> wrote in message
news:kgS_d.1164 $m63.882@newsfe 5-gui.ntli.net...[color=blue]
> 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
>[/color]