Access 2002 Pivot table. Decimal numbers incorrect

[kerrycharnley]

Hi,

Please help anyone!!!
I have created a Pivot table in Access 2002. Some of the data is decimal numbers less than 1, but the pivot table insists on rounding it down to 0.
eg 0.60 is shown as 0.00.
If I look at the table in Datasheet view, all the data looks correct
How can I stop this from happening?

Thanks

 

[SkipVought]

Hi,

Change the number format of that column.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com