If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Create a Query that Prompts for Date and Time
I am in the beginning stages of setting up a call database that tracks calls
made by sales people. The table includes separate fields for date and time. A query is needed that will prompt for a date range and time range. For example a user may want a report that shows all calls for April 1 through April 7 between 11:00 AM and 12:00 PM. I created the query for a time range, which worked. I then added the expression, for date range: =[Start Date] And =[End Date] I have also tried: BETWEEN [Start Date] AND [End Date] Both expressions get the same error when trying to run the query: "This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables." For your reference the time expression is: Between [Start Time] And [End Time] How do I set up the query to allow choosing both date range and time range? There are other criteria that will also need to be added, but thought I should get this working first. Thanks for any help you can give. Lori |
Thread Tools | |
Display Modes | |
|
|