Sorting Dates in Access

[eelsar]

I know that one can sort Ascending or Descending however when sorting dates (by selecting Ascending or Descending) in the standard format dd/mm/yy - it gets sorted by year automatically. How can I sort it by month, and within month by day and in order of year.

Thank you!

 

[JeremyNYC]

Make new fields in your query that use the DatePart function to isolate the three parts of the date, and sort by those new fields. You can display either the new fields or the original date field or both.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.