Reurn Null As Zero

[AndyShuter]

SELECT Count(qryLog4.BrokerCode) AS CountOfBrokerCode, qryLog4.GAPSold FROM qryLog4 GROUP BY qryLog4.GAPSold HAVING (((qryLog4.GAPSold)=True));

Hi, was wondering if someone could help me with this code - I wopuld like the result to return a numeric value of 0 (zero) if the result happens to be null

Many Thanks

Andy

 

[statsman]

Check the IIF function

 

[ghudson]

=IIF(IsNull([X]),0,[X])

 

[neileg]

What's wrong with the null to zero function Nz()?

 

[Bat17]

a more detailed answer could be given if you show how you are using the code

Peter