Start Date and End Date with specific times
I am trying to write a query, which will pull all records from a start date that is user defined, with a specific time and an end date that is user defined with a specific time. For example, I want all records with a [Start Date] say, 10/29/2017 and a time of 6:45am, with an [End Date] say, 10/31/2017 and an end time of 6:45am. So I would want all records from 6:45am on 10/29 through 6:45am on 10/31. Here is what I tried as criteria in my query:
Between (([Start Date])+#6:45:00 AM#) And (([End Date])+#6:45:00 AM#)
But it gave me some error. Any suggestions?
I am trying to write a query, which will pull all records from a start date that is user defined, with a specific time and an end date that is user defined with a specific time. For example, I want all records with a [Start Date] say, 10/29/2017 and a time of 6:45am, with an [End Date] say, 10/31/2017 and an end time of 6:45am. So I would want all records from 6:45am on 10/29 through 6:45am on 10/31. Here is what I tried as criteria in my query:
Between (([Start Date])+#6:45:00 AM#) And (([End Date])+#6:45:00 AM#)
But it gave me some error. Any suggestions?