Pivot Table: values always rounded

  • Thread starter Thread starter Romo via AccessMonster.com
  • Start date Start date
R

Romo via AccessMonster.com

Hello.
Something weird is happening with most of my Pivot Tables. Everytime I add a
new field into it, values are displayed rounded to 0 decimals. Since I asked
Access to display 2 decimals, all values are displayed like .00 even though
they're not always .00!
This is not happening with all my databases, just few of them. And that's the
most bizarre thing...
Any thoughts???
Thanks
 
Hello.
Something weird is happening with most of my Pivot Tables. Everytime I add a
new field into it, values are displayed rounded to 0 decimals. Since I asked
Access to display 2 decimals, all values are displayed like .00 even though
they're not always .00!
This is not happening with all my databases, just few of them. And that's the
most bizarre thing...
Any thoughts???
Thanks
Click to expand...

I suspect that the table fields upon which the pivot table query is
based are the default Number datatype - Long Integer. Integer fields
are, by definition, whole numbers.

Use Currency as a datatype instead of Number, if you need four or
fewer decimal places.

John W. Vinson[MVP]
 
Thanks very much John! You were right. I went to the original table and
changed 'Number' to 'Currency' for 2 fields and now it is working ok.
I normally work with linked tables from an ORACLE database so I always need
to create a query to post the data from those tables to a local one. It gets
a little complicate...
Again, thanks,
 
Back
Top