Hello everyone.

It seems like I am posting daily these days.  I have only been using MS
Access since Novemberish and I appreciate all of the assistance I get when I
post.

Today's issue is just a simple query trying to count only those fiels in my
table (errors) that equal Y.  When I run the query I get the message 'the
expression is typed incorrectly, or it is too complex to be evaluated.'

Here is my SQL.  Thank you for your assistance.

SELECT Errors.[User ID], Count(Errors.[Error Indicator]) AS [CountOfError
Indicator], Count(Errors.[Customer Impact?]) AS [CountOfCustomer Impact?],
Count(Errors.[Loss?]) AS [CountOfLoss?], Count(Errors.[Caught on Quality
Check?]) AS [CountOfCaught on Quality Check?]
FROM Errors
WHERE (((Errors.[Notification Date]) Between [Start Date] And [End Date]))
GROUP BY Errors.[User ID]
HAVING (((Count(Errors.[Customer Impact?]))="Y") AND
((Count(Errors.[Loss?]))="Y") AND ((Count(Errors.[Caught on Quality
Check?]))="Y"));