Sorting Dates

S

Shelly

I want to sort dates that have various years but I want them to group (sort)
by month/day. Any suggestions?
 
C

ChrisJ

Make a query where you build a field like this:
Month: Format([tblMain]![DateEntered],"mm/dd")

ChrisJ
Omaha
 
J

John Vinson

I want to sort dates that have various years but I want them to group (sort)
by month/day. Any suggestions?
Click to expand...

Two ways:

- Add a calculated field to the Query by putting

MonthDay: Format([datefield], "mmdd")

in a vacant Field cell, and sort by this; or

- Add two calculated fields Month([datefield]) and Day([datefield])
and sort by them.

John W. Vinson[MVP]
 
Top