rounding a number in a query

  • Thread starter Thread starter Saskatoon
  • Start date Start date
S

Saskatoon

I need to round a rent increase up or down to the nearest
$5. I want to do this with a calculation in a query.
I have curRent field (formatted as Currency) and
sngRentalIncrease field (formatted as Percent). When I
multiply these 2 together they have to round up or down to
the nearest $5.
Thanks in Advance.
 
I think something like....

INT(curRent * sngRentalIncrease /5 +0.5) * 5

(Assuming sngRentalIncrease holds say 1.04 for a 4% increase)

HTH
Sam
 
This seems to work anything that ends in a 2 goes down and
everything else goes up to 5, 6 goes down and the rest
round to 10. We are using varying rate increases, right
now it is 2% but will change as time goes on.
Thanks so much

Saskatoon
 
Back
Top