Decimal Places in Report compared to query

wdrspens

Registered User.
Local time
Today, 23:47
Joined
Jun 19, 2008
Messages
63
Help Please - (Access 2007)

I have a query which includes a currency calculation resulting (usually) in a decimal portion, and that calculation in the query is correct.

However when I use that calculated field in a report the decimal places are ignored and the total rounded down to the nearest whole number - rounded down always, never up.

The total is added to other figures to give a grand total, but the figure used in the total, and therefore grand total, is the rounded down figure.

The format of the calculated field in the report is Currency with decimal places set as auto. I get the same result if I change the decimal places from auto to 2.

All other fields on the report, and they are all calculated, work correctly, only this field does not.

Has anyone any ideas what I must do to ensure that it shows the decimal proportion correctly and calculatesthe grand total correctly?

Many thanks

David
 
In the format line of the textbox properties enter 0.00 (zero point zero zero) this should give you whatever the number is with 2 decimal places.
 
Thanks - I got round the problem by making the calculation a different way, but thanks anyway.
David
 

Users who are viewing this thread

Back
Top Bottom