Why does this happen?

[PearlGI]

I have a query which contains a calculated field that utilises the Nz function to deal with NULLs. This query works fine by itself.
However, when I try to call this query in VBA using the OpenRecordSet action, I get the error message:

"Undefined function 'nz' in expression"

Why does this happen and what can be done to resolve it?

Any suggestions gratefully received.

 

[mrabrams]

Check out this link.
http://support.microsoft.com/support/kb/articles/Q123/3/44.asp?LN=EN-US&SD=gn&FR=0&qry=Undefined%20function%20&rnk=2&src=DHCS_MSPSS_gn_SRCH&SPR=ACC97

Let us know if this works !!

Michael

 

[The_Doc_Man]

Since NZ is supposed to be an intrinsic function, the linked reference might not help.

I recently had this problem with the Left$ function in a query. My solution was to get the database in exclusive mode and repair it. (I'm using AC97). I got the same message you did. When I repaired the database, the problem went away.

I have no idea WHAT actually got repaired, but whatever it was, it worked.

 

[PearlGI]

Thanks Doc.

Repairing the database worked.