Eliminate nulls in queries?

[YvesX54]

Hello,

Rather then to use
MyField:Iif(Isnull(Field1);0;Field1) when building the field list in a query, there should be a function which eliminates null values (and replace them by a 0), i thought it was Znull(Field1) in Access 97 but Access2000 doesn't seem to support that ???

How wrong am i ?? :-(((

Regards,
Yves

 

[bjackson]

i think it is nz([field1],0)