how do I get my reports to list in day order vs. year order?

J

JacCeeBee

I've created a birthday report which works great except that my birthdates
for each month are in order by year. I need them in order by day. The dates
are inputted in medium date format which is used to calculate individual
ages. I'd just like to see them in order of day the birthdays will happen.
Any ideas? Thanks in advance.

Jeff
 
A

Al Camp

If your Birthday date field were named BDate, place Month(BDate) in the
first row of the report's Sorting and Grouping dialog box, and Day(BDate) in
the second row.
That will force all the BDates to list in ascending order by Month and
Day.
 
Top