How do I set decimal formats in Access pivot tables

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

Guest

The Access Pivot Table I want simply put is stores across the top, items down
the side and cost in the middle. All cost values are less than a dollar. The
Currency format showing 3 decimal places works fine in the table, other form
views and Excel data dump...just not in the Access pivot table. (The sum in
the pivot table does show the three decimal values) Currently I get the Cost
three decimal places showing zeros.
 
Hey - where's the help here??

I did find a solution from my fantastically clever friend...in the query for
the pivot table form, Cost: CDbl(Table1.Cost) fixed the problem!
 
Back
Top