Data type mismatch in criteria expression.

  • Thread starter Thread starter Tcs
  • Start date Start date
T

Tcs

I have a select query I want to use to get counts. It has two fields:

Ward PropCode
---------- ----------
Group By Count

When I do not supply any criteria, this works just fine. When I add "AP" to the
PropCode criteria, I get and error msg:

"Data type mismatch in criteria expression."

PropCode is a 4 byte text field, in my BE db (DB2 UDB on AS400). I did this
very same thing about two (2) months ago, without incident. But now?

I've searched this newsgroup for this error. What I've found implies I have a
Null. But I can't find one.

Anyone have any thoughts/ideas?

Thanks in advance,

Tom
 
Try this SQL:

SELECT Ward, Count(PropCode) AS HowMany
FROM TableName
WHERE PropCode="AP"
GROUP BY Ward;
 
Back
Top