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!
 

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 view does not show series data with decimals? 0
Access stripping decimal places in query 1
pivot table loosing decimals (vba) 1
Pivot Table rounding 3
Programmatically Modify Pivot Table Fields? 1
Display of numerical value with decimals in a text box 5
Is there a way of not showing zero totals in a pivot table? 2
Format issue ... 2 decimal places displayed? 19

Back
Top