rounding a number in a query

From: Saskatoon (nojunkreturns_at_hotmail.com)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 15:08:03 -0700

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: Two problems with field data when using Dates & Currencies
    ... include the Round() in whatever expression ... To round to the nearest 25c, ... > (query?) that would really make my day. ... >> Access adds an Update row to the grid. ...
    (microsoft.public.access.formscoding)
  • Re: If for rounding numbers
    ... - is there a if statement for my query that lookd st ... >> number to round up to the nearest whole number? ...
    (microsoft.public.access.queries)
  • Re: rounding a number in a query
    ... (Assuming sngRentalIncrease holds say 1.04 for a 4% increase) ... > I need to round a rent increase up or down to the nearest ... > sngRentalIncrease field. ... > multiply these 2 together they have to round up or down to ...
    (microsoft.public.access.queries)
  • RE: Rounding to the nearest 10
    ... "Benny" wrote: ... > I have a query that returns a value of 4342 ... > I would like to round it to the nearest 10 ie 4340 ...
    (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)