Question Pivottable Rounding

[ijswalker]

Hi,

I have a query result in datasheet view that looks just fine. However, when I change the view to Pivottable view I do not get the right summary result. This is due to the pivottable rounding the numbers. Has anyone had experience of this and do you know how to fix this in order to summaries the actual numbers to 2 decimal places and display to 2 decimal places?

Your help will be very much appreciated. I am using Microsoft Access 2003.

Thanks

Ian

 

[steven.kogan]

Check http://support.microsoft.com/kb/310264.

The rounding error applies to the Decimal data type, and is a bug. You can use the ccur, ssng, or cdec functions to convert the data type in the query, so that in the PivotTable view you will retain the decimal portion.