How to make Access asks for date range?

[hawkeye71]

Hi Folks:
I am writing a query in which I need to specify a date range, e.g. Start_Date (1/1/2004) and End_Date (1/11/2004).
When I use the 'Between #1/1/2004# and #1/11/2004#' in the criteria field, I get the desired results.

I want to make the Criteria so that when I run the query it asks me to enter the Start_Date and End_Date, instead of me specifying the date range in the QBE grid?

Thanks,
Indiana

 

[SuicidED]

In the criteria of your date field put Between [Enter Start Date] and [Enter End Date].