RE: Rounding to the nearest 10

From: Dennis <Dennis@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Mon, 18 Apr 2005 05:51:01 -0700

NewNum = Int(OldNum / 10 + .5) * 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
>
> If the value was 4346 =4350
.

Follow-Ups:
- RE: Rounding to the nearest 10
  - From: Benny

References:
- Rounding to the nearest 10
  - From: Benny

Prev by Date: Re: query to move row to different table.
Next by Date: Re: concatenating with a append query
Previous by thread: Rounding to the nearest 10
Next by thread: RE: Rounding to the nearest 10
Index(es):
- Date
- Thread

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)
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: 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)
Rounding numbers
... I have a query that sums dollars amounts and what i would ... like to do is have the results round to the nearest ...
(microsoft.public.access.queries)
Re: Round function not working in query
... > using the round function is way off. ... >> Dear Ivan: ... >> select myvalue, mydecplaces, roundas value from ... >> Then you can see the values on which the query is operating. ...
(microsoft.public.access.queries)