Create a Query that Prompts for Date and Time
Post the full SQL text of your query.
Use BETWEEN not = and =
Here is sample:
SELECT CaseNumber, Unit, CMPFiledDate, CMPRcvdDate, CMPPlus30, CMPPlus60
FROM [MyTable]
WHERE CMPFiled = True AND CMPAcpt = False AND CMPRcvdDate IS NOT NULL AND
CMPRcvdDate BETWEEN NZ([CMP Rcvd From],#1/1/1900#) AND NZ([CMP Rcvd
To],#12/31/2999#)
ORDER BY CMPRcvdDate DESC
This also shows how to set up default if user enters nothing.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
"SSi308" wrote:
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
|