Sorting Data By Day Of The Week

If you want sort by the day of the week, then you need to return the day of the week for each date and then sort the results to group the days of the week. Okay, suggest these instructions:

Tip initially comes from Susan Sales Harkins, a private consultant specializing in Access and VBA development. She currently has two technical books on the shelves: "Using Microsoft Access 97" and "Using Microsoft Access 2000." Both are QUE publications.
home button   Just click on the button for the Tiproom's Home Page.
Date of last revision: 21 August 2001.