CREATING WAY OF SHOWING CLIENTS BIRHTDAYS

[Guest]

using Access and i have created tables with clients details on. How can i get
the tables to show me clients birthdays a couple of days before they occur.
The object is to send clients cards for their birthdays?
please help

 

[Guest]

Gemma,

You could either run an AutoExec macro on loading your database, or provide
a button on your startup form that would execute a query. The following
selects all who have a birthday coming up in the next 7 days:

SELECT Client.LName, Client.FName, (other desired fields),
DateValue(Month([Birthday]) & "/" & Day([Birthday]) & "/" & Year(Date())) AS
ThisYearsBirthday
FROM Client
WHERE (((DateValue(Month([Birthday]) & "/" & Day([Birthday]) & "/" &
Year(Date())))<=Date()+7));

Hope that helps.
Sprinks