Rounding in Pivot Table View

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?
 
G

Guest

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!!!
 

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

Pivot Table rounding 3
Rounding and appending 2
Export Pivot Table to Excel 1
Unable to Group in Pivot Table 1
access 2003 pivot view 7
Pivot Table View Query as Report? 2
PivotTable View 2
Pivot Table view of Union Query 1

Top