Sorting Dates by Month

[csprop]

I have a query which lists the names and birthdates of all the people in the database. I need to sort these by month, but Access sorts dates by year.

How can I get Access to sort this list by month, then day and ignore the year? (i.e. 1/1, 1/2, 2/1, 2/2, etc.)

Thanks!

 

[KenHigg]

In the query design grid, create a month field with something like:

month: format([MyDateField], "mm")

Then sort ascending. Some thing like this can be used to do a month / year sort also...

???
ken

 

[csprop]

I did Month: format([birthdate], "mm/dd") and that worked great. Thanks a lot for your help.