Undefined function ‘Nz’ error in expression

Asked By 0 points N/A Posted on -


Why I get this annoying error message when I try to execute a query? What does the meaning of the below attached message? I hope you will be proven as a good helper and it would appreciate. Thanks for any help.

Microsoft Query

Undefined function ‘Nz’ in expression.

Answered By 0 points N/A #183555

Undefined function ‘Nz’ error in expression


Hi Joseph,

NZ() is a function within Access and sometimes while use other references for querying making use of this function, it might be unrecognized. This is why you are getting the error. NZ() is used to check for null values. I suggest you use some other function to replace the nz() with something like the IIF().

Login/Register to Answer

Related Questions