Parameter based on Date Field

[Guest]

I have a customer table with a Date of Birth field. I want to be able to
prompt a user to enter a begin and end date to print out birthday letters
based solely on the user entering the begin birth month and day and the end
birth month and day, and not the year. How can this be done?

 

[Giberish]

I have a customer table with a Date of Birth field. I want to be able to
prompt a user to enter a begin and end date to print out birthday letters
based solely on the user entering the begin birth month and day and the end
birth month and day, and not the year. How can this be done?

Have you tried creating a query based on the table with a criteria
such as:

[Enter Start Date] And [Enter End Date]

This would prompt a user to enter both a start date and end date.

 

[John W. Vinson]

The problem is that 5/16/1946 isn't coming this month... it was 61 years ago,
right? <g>

Put a calculated field in a Query by typing

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

to get this year's birthday anniversary date. A criterion of

BETWEEN [Enter start date:] AND [ENter end date:]

will let the user enter a date range; a criterion

= Date() AND < DateAdd("ww", 4, Date())

will show all birthdays coming up in the next four weeks.

John W. Vinson [MVP]