Want to create a monthly birthday report

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.
 
M

Marshall Barton

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())
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I create a birthday calendar from a tabel in access 2003? 9
problem with counting yes/no fields in a report 3
Can I link a Word Doc to an Access Report? 1
Create a report by birthmonth 1
Access report on records selected by VBA 2
Query design 2
Report with a command button 2
New Form Birthday Information Not Posting To Calendar Correctly 1

Top