Parameter based on Date Field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dh1069 - 08 May 2007 18:26 GMT

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?

Reply to this Message

Giberish - 08 May 2007 23:33 GMT

> 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.

Reply to this Message

John W. Vinson - 09 May 2007 01:30 GMT

>> 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?

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]

Reply to this Message