Sorting records by day of the week

  • Thread starter Thread starter keith_reynolds
  • Start date Start date
K

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.
 
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.
 
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.

Douglas J. Steele said:
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



keith_reynolds said:
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.
Click to expand...
Click to expand...
 
That option did work when I did it right. Thanks a million!!!!!!

Douglas J. Steele said:
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



keith_reynolds said:
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.
Click to expand...
Click to expand...
 
Back
Top