result 0 in a query

[pascal]

In a query with the field "Code" which can contain A, O, P or U I want to count all the codes with an A in it. That's not the problem, but the problem is when there are no records found with "Code" = A then the query returns an empty cell instead of 0 (zero). Can this be solved?

Thanks again, guys.

 

[RV]

Use this:

SELECT IIF(Count(Code)=0,0,Count(Code))

Suc6,

RV

 

[pascal]

Thank you very much RV.