Sorting dates by the month

  • Thread starter Thread starter Robin Chapple
  • Start date Start date
R

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
 
Add a calculated field to your query, and sort on it. Something like
Format([MyDateField], "mmdd") will work.
 
Back
Top