Reporting Birthdays

  • Thread starter Thread starter Fons Ponsioen
  • Start date Start date
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
Click to expand...
I get a report (or query?) to only show/return folks with
birthdays within the next 30 days.
 
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
Click to expand...
I get a report (or query?) to only show/return folks with
birthdays within the next 30 days.
 
Back
Top