Poon's Blog

the microsoft access 2003: Nz() function

usage : FOR EXAMPLE:

Nz(var1,0)

then if var1 is null, it return 0,if var1 is not null,

it return var1 's value.

as we can see , it's very easy to use.

but recently i used it in my access query ,

when i invoked that query in the brio report ,

and found that there is not any reponse ,

in other words, the query could not be quoted by brio.

when is substitute the Nz() function by IIf(),

and the query can be successfully invoked !