Access Pivot Table Report

J

javablood

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 zeroes. These other numbers appear to be from another
field in the Access table but that field is not selected as Values in the
pivot table. I am not sure if it is related to the Value Field Setting of
"Sum" but since there is no "First" that is the closest choice.

Any ideas?

Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Doughnut Chart linked with the slicer in the pivot table 0
Dates In Excel 5
Append Crosstab Query to Existing Table 0
Setting column width in a table with a macro is not working 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Pivot Table link/export 0
Slicers and Calculated Items in Pivot Table 2

Top