P
punter_maharaj
I have generated a query from combination of a few tables. This query has
data in numeric format, often with decimals. The Datasheet view shows the
numeric data with all decimals and fractions. But the PivotTable view ignores
the fraction portion. It does not display digits to the right of decimal
point. Thus, any totaling calculation is also resulting in decimal error.
Any idea why PivotTable in Access is not displaying fraction part in MS
Access? I don't think that this happens in MS Excel.
data in numeric format, often with decimals. The Datasheet view shows the
numeric data with all decimals and fractions. But the PivotTable view ignores
the fraction portion. It does not display digits to the right of decimal
point. Thus, any totaling calculation is also resulting in decimal error.
Any idea why PivotTable in Access is not displaying fraction part in MS
Access? I don't think that this happens in MS Excel.