Data Type Mismatch

[Love Buzz]

Hi all.

I am just trying to group a query by certain criteria. When I set the queue
as 11, I get the data type mismatch message. This is a relatively simple
query...I think. Here is my SQL. What am I doing wrong? Thanks for your
help.

SELECT [ANF Analysis].[Rej Date], [ANF Analysis].Queu, [ANF
Analysis].Operator, Count([ANF Analysis].Queu) AS CountOfQueu
FROM [ANF Analysis]
GROUP BY [ANF Analysis].[Rej Date], [ANF Analysis].Queu, [ANF
Analysis].Operator
HAVING ((([ANF Analysis].Queu)="11"));

 

[KARL DEWEY]

If [ANF Analysis].Queu is a number field then it should read like this --
HAVING ((([ANF Analysis].Queu)=11));

No quotes if a number, quotes for a text field.

 

[Jeff Boyce]

Is there a chance the field you're querying is set up in the table
definition as a "lookup" data type field?

Regards

Jeff Boyce
Microsoft Office/Access MVP