In a query, how can I sort a date field, so that the records that come back are in order

15 June
21 August
6 September

E.t.c.

Thanks

Add another column and put this in the Field - ByMonth: Month([YourDateField]). Then uncheck the Show check box and set Sort to Ascending.

Hmmm......

Jack what about the Year that you have not accounted for .....

RDH

I took him at his word and left off the year part. And I wanted to see if you were alert!

Thanks Jack...

From the code you have for the month, I am assuming that the code for the year will be:

ByYear: Year([Datefield])

Thnx