Re: rounding a number in a query

From: Saskatoon (anonymous_at_discussions.microsoft.com)
Date: 04/30/04 

Date: Thu, 29 Apr 2004 20:10:10 -0700

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
>-----Original Message-----
>I think something like....
>
>INT(curRent * sngRentalIncrease /5 +0.5) * 5
>
>(Assuming sngRentalIncrease holds say 1.04 for a 4%
increase)
>
>HTH
>Sam
>
>"Saskatoon" <nojunkreturns@hotmail.com> wrote in message
>news:627a01c42e36$711db320$a601280a@phx.gbl...
>> 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.
>
>
>.
>

Relevant Pages

  • Re: Hillary Clinton Gives Driving Advice
    ... Right now we round every price to the nearest $0.01; ... would have to do would be to round to the nearest $0.1 instead. ... How about restoring value to currency instead of inflating it? ...
    (rec.autos.driving)
  • Re: Fastcode RoundTo
    ... The rounding control could be like the following: ... {Round to nearest else to even digit. ... drHalfOdd, {Round to nearest else to odd digit. ...
    (borland.public.delphi.language.basm)
  • Re: How do I round down currency in Excell?
    ... "NTG" wrote in message ... > I was trying to get the currency to round down to the nearest 5 cent ...
    (microsoft.public.excel.misc)
  • Re: Hillary Clinton Gives Driving Advice
    ... Right now we round every price to the nearest $0.01; ... would have to do would be to round to the nearest $0.1 instead. ... How about restoring value to currency instead of inflating it? ...
    (rec.autos.driving)
  • Re: Win32Forth & negative zero
    ... >>>Round to nearest/even is not necessarily better than others. ... nearest with even tie breakers "IEEE rounding", ... has four rounding modes, labeled in C99 as FE_TONEAREST, ... In particular C99, which I think is getting it right, and ought ...
    (comp.lang.forth)