Undefined function ‘Nz’ error in expression

Asked By Joseph A Reese 0 points N/A Posted on - 09/12/2013

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.

• Status: Open
• Question Views: 1109
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Software

Answered By Merry Hock 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().

About Merry Hock

Questions
0

Answers
99

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 11/12/2013
• Question Category: Misc Software