Error message in Data Access Page

[alanponeill]

Hi all,

I am trying to run a data access page from explorer. When I call the page I get the message "Undefined function NZ in expression". The data source for the page is a query which contains the NZ function in an expression. Anybody know how I can retain the use of the this function in the data source whilst enabling the data access page to function.

Thanks,

Alan

 

[Norie]

Alan

Could you replace the Nz with an Iif?

I don't know much about data access pages but perhaps that might work.