Birthday Report

[Claude Alain]

Hello!

We are a small non-profit organisation with about 400 members. We have
created a database using Access97 which contains tombstone information on
our members, including home adresses and birthdates. We would like to
produce monthly reports providing us with a list of all members whose
birthdate is coming up during any given month in order to send those members
a birthday card in a labelled enveloppe. The best we have come up with so
far is one lengthy report of all members sorted by month of their birthdate,
i.e, all those born in September 1939, followed by October 1939, through to
December 1939, then January 1940, February 1940, and so on and so forth.

BTW we are all newbies.

Any ideas. Any help would appreciated. TIA.

C. Alain

[Pavel Romashkin]

You can base the report on a query that will give you only the people
whos birthday is during this month. You can automate the report to run
on the 15th of the month:

SELECT FirstName, LastName, Address, BDate FROM MembersTable WHERE
Month(BDate) = Month(Now() + 20)

+20 is so that you get the people whos birthday is next month and don't
be late tosend cards to those whos birthday is in the first days of the month.
You also should probably make the report based on the above query in the
form of mailing label layout to print out mailing labels right away.

Good luck,
Pavel

Claude Alain wrote:

Hello!

We are a small non-profit organisation with about 400 members. We have
created a database using Access97 which contains tombstone information on
our members, including home adresses and birthdates. We would like to
produce monthly reports providing us with a list of all members whose
birthdate is coming up during any given month in order to send those members
a birthday card in a labelled enveloppe. The best we have come up with so
far is one lengthy report of all members sorted by month of their birthdate,
i.e, all those born in September 1939, followed by October 1939, through to
December 1939, then January 1940, February 1940, and so on and so forth.

BTW we are all newbies.

Any ideas. Any help would appreciated. TIA.

C. Alain