Rounding in Pivot Table View

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a query in Access 2002. Then, I went into Pivot Table view and created a pivot table. I plan to download the pivot table (and backup data) into Excel. However, I'm having a problem with the data. The amounts, that I have saved as "currency" are being rounded to the nearest dollar. The data in datasheet view is NOT rounded, but it rounds in the Pivot Table view for some reason. I've tried everything I can think of to stop the rounding, but have been unsuccessful

Does anyone have any ideas on how to stop the rounding?
 
I found the solution...refer to Microsoft Knowledge Base Article - 310264
I created a column/field in Datasheet view and used function "CDbl" on the amount column...this allowed the decimals to show in my Pivot Table view. It worked!!!
 
Back
Top