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 !

so , BOTH Nz() and IIF() CAN be understand by access.

by brio can only understand IIF(),it can't do anything with Nz().

brio connect to ACCESS via SYSTEM DNS using the ODBC driver..

so maybe the ODBC do not support Nz().