N/APosted on - 09/12/2013
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.
Undefined function ‘Nz’ in expression.
Undefined function ‘Nz’ error in expression
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().