Rounding up of decimal values

  • Thread starter Thread starter Richard
  • Start date Start date
R

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
 
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
 
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

Clifford Bass said:
Hi Richard,

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

Clifford Bass

Richard said:
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
Click to expand...
Click to expand...
 
Back
Top