Need date parameter on one of many date fields

D

Donna

I have a report based on a table that has several "deadline" date fields.
Preliminary Review Date
Department Staffing Date
Command Review Date
Senior Staff Review Date

I would like to have the user enter a date and then choose which field this
date parameter will look at. i.e., it will show me all policy revisions
where the date of one of those fields listed above that the user selects is
less than the date the user enters.

Can this be done?
Thanks in advance.
 
A

Allen Browne

Create a query into this table.

In the Criteria row below each of the 4 fields, enter the same expression:
<= [WotDate]

Use any name you wish, but declare it by choosing Parameters on the Query
menu, and entering this line into the dialog:
WotDate Date/Time

If you prefer the query to read the value from a form, you can use a name
such as:
[Forms].[Form1].[Text0]
where "Form1" represents the name of your form, and "Text0" represents the
name of your text box. Set the text box's Format property to Short Date so
it accepts dates only, and declare the parameter.
 
Top