Reporting Birthdays

F

Fons Ponsioen

Hi Greg.
Using a query for your report in the DOB column criteria
enter >= Now() and <(Now()+31)
Hope this helps
Fons
-----Original Message-----
I have a "date of birth (DOB)" field in a table. How to
I get a report (or query?) to only show/return folks with
birthdays within the next 30 days.
 
R

Rick B

Ummmmm, Fons. That won't work unless you are looking for birthdates of
unborn babies :)

You need to limit your criteria to only look at the month and day.

Rick B

Hi Greg.
Using a query for your report in the DOB column criteria
enter >= Now() and <(Now()+31)
Hope this helps
Fons
-----Original Message-----
I have a "date of birth (DOB)" field in a table. How to
I get a report (or query?) to only show/return folks with
birthdays within the next 30 days.
 
Top