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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top