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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sorting (I think) 1
Reports - setting up data order 1
How do I sort a report on date fields from two tables? 3
Get fiscal year to show in a report 4
How Do You Order an Aggregate Function 2
How can I set up a custom sort order,Access reports ie. S,M,L,XL 1
How do I set up my report in date order? 4
How do I sort by month and day 5

Top