query asking for a range in dates

[CThai]

hello -

how do you have access ask the user to enter a range of dates e.g., 5/1/08-5/15/08

right now i just have it ask for one date Like '*' & [Please Enter a date] & '*' ... but i would like it to ask them to enter a range of date...

 

[LxQ]

& [Please Enter a date] & [Please Enter another date] & '

then depending on how you do this.. if it's in a query, the criteria would be:
>=[Please Enter a date] And <=[Please Enter another date]

 

[Norie]

Use Between in the criteria.

Between [Start Date] And [End Date]