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