Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Please Help: Pivot Table is Rounding off decimals to 0
I think I found the answer, looking on a different discussion board. Please reference Microsoft Knowledge Base Article 310264 http://support.microsoft.com/default.aspx?scid=kb;en-us;310264&Product=acc2002 If you want to save the web click trip, keep reading. :) Hope this helps, it worked...- brettbum
- Post #12
- Forum: Microsoft: Access Other topics
-
Please Help: Pivot Table is Rounding off decimals to 0
I'm currently experiencing the same problem that Markphsd describes. I have a query that pulls numbers (netsales) in currency format. However the numbers to the right of the decimal get dropped off when I flip to pivot table view. The decimals are there in data sheet view, if I export to...- brettbum
- Post #11
- Forum: Microsoft: Access Other topics
