Pivot Table link/export
 

I have a Pivot Table Report in Excel that is connected to a query in Access.
The query will either provide a zero (0) or another number based on a
condition. The query works fine in Access but the Excel table has numbers
where it should have zeros. I get the same result if I just import the data
as a table instead of a pivot table. However, if I export the query into
Excel everyting is just fine!

I want/need to keep my Excel linked to the Access to update my charts. Can
anyone help?

thanks,
--
javablood