Birthday list by month

[Soyful]

I have grouped my report my month but it also separates by year. I would like
a report of birthdays by month regardless of they year of birth. Is that
possible? Thanks.

 

[Al Campagna]

Soyful,
Use the Month(YourDate) to assign a value to every record (1-12).
Then group your report on that value.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[BruceM]

One way is to use this as the Grouping expression in the report:

=DateSerial(Year(Date()),Month([BirthDate]),1)

I would use a group header. In the header put a text box bound to
BirthDate, formatted as mmmm. Force a new page before the section (on the
group header property sheet). These are formatting choices that will not
affect the basic idea one way or the other.

 

[fredg]

I have grouped my report my month but it also separates by year. I would like
a report of birthdays by month regardless of they year of birth. Is that
possible? Thanks.

Group it by month instead of month and year.

In Report Design View. click on View + Sorting and Grouping
In the Report's Sorting and Grouping dialog:

Field/Expression Sort
=Month([DateOfBirth]) Ascending

 

[BruceM]

Ah! That's the one I was trying to think of. Tidier than DateSerial.

I have grouped my report my month but it also separates by year. I would
like
a report of birthdays by month regardless of they year of birth. Is that
possible? Thanks.

Group it by month instead of month and year.

In Report Design View. click on View + Sorting and Grouping
In the Report's Sorting and Grouping dialog:

Field/Expression Sort
=Month([DateOfBirth]) Ascending