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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A spin on a common question. DateAdd 2
Exclude records based on the day of the week name (e.g. Monday) 6
Access Dcount (multiple criteria) 3
Sort by Date 4
Random Function for Selecting Records 3
1 day from becoming overdue and or past due records at the top 4
Want a counter for Access Query results 8
complex query to pull unique values 6

Back
Top