Re: rounding a number in a query

From: Sam D (sam)
Date: 04/30/04 

Date: Fri, 30 Apr 2004 10:20:43 +1000

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

  • rounding a number in a query
    ... I need to round a rent increase up or down to the nearest ... I want to do this with a calculation in a query. ... sngRentalIncrease field. ...
    (microsoft.public.access.queries)
  • Re: rounding a number in a query
    ... >> I need to round a rent increase up or down to the ... >> I have curRent field (formatted as Currency) and ... >> sngRentalIncrease field. ... >> the nearest $5. ...
    (microsoft.public.access.queries)
  • 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: 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)
  • Re: Burette/Thermom. Readings - Rounding?
    ... >I realised I don't know how to round values from thermometers, burettes ... then you round DOWN to 20.00; else if it is above the halfway ... >to the upper or lower regions inbetween the divisions. ... You have decided to read to the nearest 5 in the last ...
    (sci.chem)