Sort Month and Sort Day

[Guest]

Hi,
If i remember right, I need to take advantage of the Expression function of
the queries to Sort by month and day and do it in seperate fields? The HR
person has a table employees and it has their birthday (mm/dd/yyyy) and I
can't remember how to do this query? If i do it in ascending order w/ out
sorting my month and day 12/31/1981 will come before 1/1/2000 and i don't
look at the year. Thanks

 

[Rick B]

You can put the month in one field using BirthMonth:
DatePart("m",[birthdate])
uncheck the display box (since it is only for sorting)

In the next field you can put the day as BirthDay:
DatePart("d",[birthdate])

Hope that helps,
Rick B