Parameter Query

A

Alexander

Dear all,

I have two field, "Begining Date" and "Ending Date"

I would like to make a paramater query to prompt the user to key in a
begining date and a ending date, and it will show all the data within the
two date range.

What should I do?

Thank You.

Cheers!
 
B

berk

in the criteria section for Beginning date, type this:
=[Enter From Date]
Click to expand...
in the criteria section for the ending date, type this:
<=[Enter To Date]

Make sure you use the brackets.
 
J

John Spencer (MVP)

Field: BeginingDate
Criteria: <=[End of Period Date]

Field: EndingDate
Criteria: >=[Beginning of Period Date]

This will show all records where some portion of the range between your two
fields lies between the two dates you input as parameters.
 
Top