sorting by day of the week??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with a field called "day" which is just "monday" "tuesday"
etc. for a list of weekly appointments I keep. I used a text field only
because there is no option to just put the day of the week as a date field
datatype. Now I can't sort it by day of the week; if I sort alphabetically,
it gives me the days in alphabetical order.

How can I sort by date (monday first, etc.)??

Thanks.
Barbara
 
dwae2000 said:
I have a table with a field called "day" which is just "monday"
"tuesday" etc. for a list of weekly appointments I keep. I used a
text field only because there is no option to just put the day of the
week as a date field datatype. Now I can't sort it by day of the
week; if I sort alphabetically, it gives me the days in alphabetical
order.

How can I sort by date (monday first, etc.)??

Thanks.
Barbara
Click to expand...

Use a date field formatted to show the day of the week and a calculated
field to show the day number, sort on the number.

You could also use a table with fields for the day number and name. This
would allow a combobox to fill in the date and number.
 
Back
Top