Want to create a monthly birthday report

  • Thread starter Thread starter Colette B.
  • Start date Start date
C

Colette B.

I am running Access 2000 and have created an Address book
with Birthday fields for at least 4 different people in a
family (Birthday, Spouse Birthday, Child 1 Birthday, etc.).

I would like to create a report that shows only the
birthdays for the current month.

If anyone could provide some help I would appreciate it.
Thanks,
Colette B.
 
Colette said:
I am running Access 2000 and have created an Address book
with Birthday fields for at least 4 different people in a
family (Birthday, Spouse Birthday, Child 1 Birthday, etc.).

I would like to create a report that shows only the
birthdays for the current month.
Click to expand...


Create a query based on the address book table. Add a
calculated field something like:

Bmonth: Month(Birthday)

Use a criteria under it:

=Month(Date())
 
Back
Top