G
Guest
I have written the following query and am getting the error message " The
expression is typed incorrectly, or 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"
<b>SELECT DateValue(Calls.CallDateTime) AS CallDate, Count(Calls.Subject) AS
Subject1
FROM Calls
WHERE Calls.CallType=6
GROUP BY DateValue(Calls.CallDateTime)
HAVING DateValue(Calls.CallDateTime) Between
DateValue(Forms!frmDateRange!txtStartDate) And
DateValue(Forms!frmDateRange!txtEndDate);</b>
The problem has to do with the CallType having a value of 6. The CallType
field can have a value anywhere from 1-12 and it works fine for all of them
except for 6. Does anyone have an idea what the culprit might be for this?
expression is typed incorrectly, or 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"
<b>SELECT DateValue(Calls.CallDateTime) AS CallDate, Count(Calls.Subject) AS
Subject1
FROM Calls
WHERE Calls.CallType=6
GROUP BY DateValue(Calls.CallDateTime)
HAVING DateValue(Calls.CallDateTime) Between
DateValue(Forms!frmDateRange!txtStartDate) And
DateValue(Forms!frmDateRange!txtEndDate);</b>
The problem has to do with the CallType having a value of 6. The CallType
field can have a value anywhere from 1-12 and it works fine for all of them
except for 6. Does anyone have an idea what the culprit might be for this?