Showing decimals in Access pivot table

[eskil]

Hi,
I am running a pivot table based on a query. I need to be able to
display decimal precision for on a calculated field (in the query).

The query returns the values correctly (i.e. with the number of
decimals specified), the pivot table - when viewed as a regular form -
shows decimals, but the pivot itself displays only the suffix ,00.

I am using Access 2003.

Your help will be much appreciated.

Eskil

[Ed Robichaud]

Open your pivot table form in design view, select the calculated control(s)
that you want formatted, view properties, then set the Format to fixed or
standard, and Decimal Places to the required number. Close, save and view;
your controls will now show the decimal precision that you specified.
-Ed
"eskil" <es********@hotmail.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...

Hi,
I am running a pivot table based on a query. I need to be able to
display decimal precision for on a calculated field (in the query).

The query returns the values correctly (i.e. with the number of
decimals specified), the pivot table - when viewed as a regular form -
shows decimals, but the pivot itself displays only the suffix ,00.

I am using Access 2003.

Your help will be much appreciated.

Eskil

[cjb_kjb]

As far as I can see this doesn't work. Changing the field to fixed
only puts .00 on the end - eg 2 now shows as 2.00 not 2.34 as it really
should be.
Ed Robichaud wrote:

Open your pivot table form in design view, select the calculated control(s)
that you want formatted, view properties, then set the Format to fixed or
standard, and Decimal Places to the required number. Close, save and view;
your controls will now show the decimal precision that you specified.
-Ed
"eskil" <es********@hotmail.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...

Hi,
I am running a pivot table based on a query. I need to be able to
display decimal precision for on a calculated field (in the query).

The query returns the values correctly (i.e. with the number of
decimals specified), the pivot table - when viewed as a regular form -
shows decimals, but the pivot itself displays only the suffix ,00.

I am using Access 2003.

Your help will be much appreciated.

Eskil