Pivot Table defaults autosum values to nearest whole number

[Guest]

How can I get Access 2003 to display and calculate to a 3 place decimal?

When the value is 0.051, the pivot table defaults to 0.

If I multiply the value by 100 (5.1), the pivot table defaults to 5.

 

[PC D]

Your number field in your table is set to Integer or Long Integer. Set it to
Single or Double.

 

[Guest]

PC D

Thanks for the suggestion. It wasn't exactly the solution but it gave me
the suggestion I needed to solve the problem.

Thanks again

REW

 

[StopThisAdvertising]

"PC D" <[email protected]> schreef in bericht
--

PC Datasheet
Your Resource For Help With Access, Excel And Word Applications 'Resource ????
Over 1175 users have come to me from the newsgroups requesting help '1175 users ????
(e-mail address removed)

--
To Steve:
Why PC D ? Why not PCD anymore, or Access Resource or Help available or why not just PC DataSheet?
You think that changing names is vital for you? It seems like a second nature but ...
No-one wants your advertising/job hunting here!
Over 700 !! users from the newsgroups have visited the website to read what kind of a 'resource' you are... (rapidly increasing..)

To the original poster:
Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html

Arno R