Sorting dates by the month

[Robin Chapple]

I have a report that records dates that we need to send anniversary
greetings.

I need the complete date to be displayed but I need to sort by day and
month.

Sounds impossible.

Thanks,

Robin Chapple

 

[Douglas J. Steele]

Add a calculated field to your query, and sort on it. Something like
Format([MyDateField], "mmdd") will work.

 

[Robin Chapple]

Thanks Doug,

Worked beautifully first time.

Robin