Undefined function ‘Nz’ error in expression

Asked By 0 points N/A Posted on -
qa-featured

Hi,

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.

SHARE
Answered By 0 points N/A #183555

Undefined function ‘Nz’ error in expression

qa-featured

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().

Related Questions