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.