Round to a Multiple

[mh]

In an Access Report how do i round to the nearest multiple?

ex. 45263 Round to 45260
45266 Round to 45270

Thanks,

 

[John W. Vinson]

In an Access Report how do i round to the nearest multiple?

ex. 45263 Round to 45260
45266 Round to 45270

Thanks,

Multiple of 10?

10*Round([field]/10,0)

John W. Vinson [MVP]

 

[Allen Browne]

There's a bunch of rounding info here:
http://allenbrowne.com/round.html#RoundNegativePlaces