Access 2002, Pivot Table & decimals

[CM]

Hello All,

I am trying to create a pivot table off of a "total query". On my
table & the query itself, I have the currency field set for no
decimals (on the total, I have this set as a SUM. When I run the
query, the data is correct, however when I create the pivot, it shows
the currency with the decimal places.

I have also tried to create a regular query based upon my "total
query" & still get the same result


Any suggestions?

Thanks