Pivot Table: values always rounded

[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

 

[John Vinson]

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

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]

 

[Romo via AccessMonster.com]

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,