sorting by day of the week??

[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

 

[Mike Painter]

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

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.