Sorting records by day of the week

[keith_reynolds]

Is there a way to sort records by the day of the by using a date field.
I can format the field by using ddd or dddd but I need to find a way to sort
the records by this field.

 

[Douglas J. Steele]

Not sure what you're looking for. Are you trying to get them to sort in
Sunday, Monday, Tuesday order, rather than alphabetically? If so, add
another computed field to your query: Weekday([MyDateField]), and sort on
it.

 

[keith_reynolds]

Yes, I am trying to sort them by Sunday, Monday, Tuesday order, rather than
alphabetically. Tried your option and it still sorts by the date rather then
by day.

Not sure what you're looking for. Are you trying to get them to sort in
Sunday, Monday, Tuesday order, rather than alphabetically? If so, add
another computed field to your query: Weekday([MyDateField]), and sort on
it.
--
Doug Steele, Microsoft Access MVP

Is there a way to sort records by the day of the by using a date field.
I can format the field by using ddd or dddd but I need to find a way to sort
the records by this field.

 

[keith_reynolds]

That option did work when I did it right. Thanks a million!!!!!!

Not sure what you're looking for. Are you trying to get them to sort in
Sunday, Monday, Tuesday order, rather than alphabetically? If so, add
another computed field to your query: Weekday([MyDateField]), and sort on
it.
--
Doug Steele, Microsoft Access MVP

Is there a way to sort records by the day of the by using a date field.
I can format the field by using ddd or dddd but I need to find a way to sort
the records by this field.