Does anyone know how I can create a query that will let the user input a start date and an end date, and then show the results between specific, pre-determined times?
For example: I want the user to be able to enter 8/8/07, when asked for the start date. Then enter 8/9/07 when asked to enter the end date. After hitting enter, I want the results to return everything input into the table on 8/8/07 from 11:00am untill 11:00am on 8/9/07.
I believe it is possible to do what I need to do, but am not sure how to do it. I am sure there is an easy solution and I am just overlooking it.
Currently I have: Between [Enter START Date (m/d/yy)] And [Enter TODAY’S Date (m/d/yy)]:in the Criteria box when the query is in design view. I am getting all the correct dates but want to filter the time to show >=11:00am on the start, and <=11:00am on the end. Any help on this would be greatly appreciated! Thanks, Jon
