Automated report

[Guest]

I am trying to work out how to make an automated report. What i am need to do
is organise for a list to be automatic to show any fields with the current
day and next days date.
For example i need an automated report for anyone who has a birthday that
has the same date as the current day in the birthday field.

I also need the how to do this for dummies explanation if possible.

Thanks

 

[John Vinson]

I am trying to work out how to make an automated report. What i am need to do
is organise for a list to be automatic to show any fields with the current
day and next days date.

For a Date field use a criterion of

BETWEEN Date() AND Date() + 1

For example i need an automated report for anyone who has a birthday that
has the same date as the current day in the birthday field.

I also need the how to do this for dummies explanation if possible.

For a birthday, you really should be storing the date of birth in a
Date/Time field (called DOB for example). Naturally that will be in
the past (60 years and some in my case)... and won't be between Date()
and Date() + 1!

Therefore, put a calculated field into the Query by typing

HappyHappy: DateSerial(Year(Date()), Month([DOB]), Day([DOB]))

to calculate this year's birthday anniversary. Use the same criterion,
Between Date() And Date() + 1, to find today's and tomorrow's (not
Sunday's if today is Friday, is this a work week issue...?) birthdays.

John W. Vinson[MVP]