Pivot Table rounding

I setup a pivot table in Access. The property for the values is two decimal
places. When I view as a Pivot Table, Access is rounding the stored values.
When I look at the data in datasheet view, the values aren't rounded.

Any idea how to stop the pivot table from rounding?

Ben

For example, I have the following values in the field CMSN_AMT: 366.10;
188.34; 24.95. When I view these values in the Pivot Table (to sum CMSN_AMT)
by other filters, the values show as 366.00; 188.00; and 24.00; respectively.

Any ideas? The correct numbers are displayed in Datasheet view - just not
as a Pivot Table.

Thanks
Ben

"Ben" wrote:

I setup a pivot table in Access. The property for the values is two decimal
places. When I view as a Pivot Table, Access is rounding the stored values.
When I look at the data in datasheet view, the values aren't rounded.

Any idea how to stop the pivot table from rounding?

Ben

Ben wrote:
| I setup a pivot table in Access. The property for the values is two
| decimal places. When I view as a Pivot Table, Access is rounding the
| stored values. When I look at the data in datasheet view, the values
| aren't rounded.
|
| Any idea how to stop the pivot table from rounding?

In PivotView click your value, properties format number format

--
KN

Tried that - didn't work.

For example, I have the following values in the field CMSN_AMT: 366.10;
188.34; 24.95. When I view these values in the Pivot Table (to sum CMSN_AMT)
by other filters, the values show as 366.00; 188.00; and 24.00; respectively.


"Krzysztof Naworyta" wrote:

Ben wrote:
| I setup a pivot table in Access. The property for the values is two
| decimal places. When I view as a Pivot Table, Access is rounding the
| stored values. When I look at the data in datasheet view, the values
| aren't rounded.
|
| Any idea how to stop the pivot table from rounding?

In PivotView click your value, properties format number format

--
KN
.