Rounding up of decimal values

[Richard]

I need to know how to round any figure after a decimal point to even if its
less than 5...

e.g. 2.0433 to 2 decimal place = 2.04

but I want 2.0433 to 2 decimal place = 2.05 instead of 2.04

 

[Golfinray]

Round([yourfield],2)

 

[Clifford Bass]

Hi Richard,

Try Round([myfield] + .05, 2).

Clifford Bass

 

[John Spencer]

This expression should work for positive numbers.

-Int(-SomeNumber * 10^2)/10^2

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Clifford Bass]

Hi Richard,

Oops, missed a decimal place.

round([myfield] + 0.005, 2)

And if you might have negative numbers that you want to round down
instead of up you could try:

sgn([myfield]) * round(abs([myfield]) + 0.005, 2)

Clifford Bass

Hi Richard,

Try Round([myfield] + .05, 2).

Clifford Bass

I need to know how to round any figure after a decimal point to even if its
less than 5...

e.g. 2.0433 to 2 decimal place = 2.04

but I want 2.0433 to 2 decimal place = 2.05 instead of 2.04