Public Function

I use a built-in function in an Access db in some select qry's.

From excel, i create an access qry, open the recordset, and then copy it to a specified range. This always works except for when i use this specific function in the sql string.

Then i get a msg undefined function.
Function being used is Nz()

It does not seem like this should be an issue. Does anyone have any ideas.

Thanks in advance.

Thanks for the reply.

Creating the function in Excel still results in an undefined function error.

I know i can change this using a simple iif statement but the select qry is calling other queries also using Nz(). This means i would have to go back and change Nz everywhere to an iif statement. Very cumbersome.

Even tried making a table by just executing the qry in access and not returning data to excel and then qry the table, but using querydefs("").execute also result in an error.

Please Login or Register  to view this content.

Any ideas helpfull.
Thanks again