Sorting by Month Only, Not Month and Year in a Report.

[Kjonnnn]

Hello Access Geniuses.

I've searched the site and other place for a solution.

I have a database were I can create a report for just names and birth MONTHS.

I can easily get it to sort by MONTH, but its sorts by Month, then Year. I need to have all of a month's detail items grouped together regardless of the year. Specifically, this for birthdays.

For the section header I get =Format$([Birthdate],"mmmm yyyy",0,0)
This gives me MONTH, YEAR

If I change it to =Format$([Birthdate],"mmmm")
just the month is display, but it still sorted by month, then year, (i.e. I'd have multiple Januarys because of birthdays being is different years).

Also, in my query, I have a field that will convert the Birthdate to a month number. Then when creating the report using the Month Number, instead of the Birthdate, I just get numbers.

Any ideas? Thanks.

 

[dhookom]

You should be able to sort on the expression:
=Month([Birthdate])


Duane
Hook'D on Access
MS Access MVP