Pivot tables in Excel using Access external database with NZ

I have an Access database query where I have used the NZ function (adding fields together, where some fields are blank). If I try to use this Access database query when creating a pivot table in Excel (choosing external data source), I get the following message:

Undefined function 'Nz' in expression.

Why and how can I avoid this?
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!