 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / November 2007How do I set decimal formats in Access pivot tables
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! > 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.