Birthdays by month

[Caryn]

I have a database with birthdays.

1. I would like to produce a report listing just month
and day. The field is formatted with the date/time format.

2. I would like the report to list each month and the
birthdays that fall in that month together. For example.

January
Jim Smith 1/12
Sally Jones 1/19

February
Mary Washington 2/22

Thanks.

Caryn

 

[Marshall Barton]

I have a database with birthdays.

1. I would like to produce a report listing just month
and day. The field is formatted with the date/time format.

2. I would like the report to list each month and the
birthdays that fall in that month together. For example.

January
Jim Smith 1/12
Sally Jones 1/19

February
Mary Washington 2/22

Set the report Sorting and Grouping (View menu) to
=Month(bdatefield). Specify Yes for the group's Header
property, then add a text box to the group header and use
the expression =Format(bdatefield, "mmmm")