Rounding

[John]

Hi
How to I get a calculated figure of £1.925 to show as £1.92
This is a calculation for the VAT paid on a total price of £11.00
I need this to show the true figure to 2 decimal places not the rounded
figure access shows.
I know that calculations are based on the true figures of £1.925 but I need
it to show on my form as £1.92

Regards

John

 

[Marshall Barton]

How to I get a calculated figure of £1.925 to show as £1.92
This is a calculation for the VAT paid on a total price of £11.00
I need this to show the true figure to 2 decimal places not the rounded
figure access shows.
I know that calculations are based on the true figures of £1.925 but I need
it to show on my form as £1.92

If you're saying that you just want to throw away anything
beyond the second decimal place, then use an expression in
the text box:

=Int(amount * 100) / 100

 

[John Nurick]

=Int(amount * 100) / 100

Int() may not give the desired result for amounts less than zero; if so,
use Fix() instead.