Dear All,
I have a few Access databases where I have certain queries the results of which are displayed in Excel, so I created Pivot tables in Excel with reference to an external data source: my Access database
My problem is that it works fine except when there is an NZ function used in the query, in that case I cannot even see the query in the selection list of the external data source in Excel
I also tried to create another select query based on the query with the NZ function but Excel still cant see the new query either
Solution could be to make a make-table query but that I find rather cumbersome....
Could you please advise how to make those nz queries visible/usable for pivots as well?
Many thanks in advance![Wink ;) ;)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I have a few Access databases where I have certain queries the results of which are displayed in Excel, so I created Pivot tables in Excel with reference to an external data source: my Access database
My problem is that it works fine except when there is an NZ function used in the query, in that case I cannot even see the query in the selection list of the external data source in Excel
I also tried to create another select query based on the query with the NZ function but Excel still cant see the new query either
Solution could be to make a make-table query but that I find rather cumbersome....
Could you please advise how to make those nz queries visible/usable for pivots as well?
Many thanks in advance