Birthdays by month

  • Thread starter Thread starter Caryn
  • Start date Start date
C

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
 
Caryn said:
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
Click to expand...

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")
 
Back
Top