Pivot Table Rounding Issues

[mattalin]

I set up a pivot table recently in Access and for some reason it seems to be rounding the data to the point where the accuracy of my data is compromised.

When I export the data (datasheet) to excel and run pivot table there is no rounding.

Is there a way to fix this in Access?

 

[pooratlas]

Is it possible you mean decimals are being rounded? Or a control's property is rounding?
Are these stored values or calculated values?

 

[mattalin]

yes, the decimals are being rounded in the pivot table (Access). The property is two decimal places but when the Access pivot is created, it seems to be rounding. These are stored values.

 

[pooratlas]

Double clicking on the Access pivot form should open the pivot table in Excel. Format the range of values in Excel and close Excel. The resulting format should appear in the Access pivot form.