Microsoft Access Round a Number to the Nearest 10, 100, etc. (Rounding)

In this Microsoft Access tutorial, I&going to show you how to round any number to the nearest 10, 100, etc. You&also see how to round up, down, and avoid "banker&rounding." FORMULAS: R: 10 - round to the nearest 10 Nearest: [R]*(Round([X]/[R],0)) RoundDown: [R]*Int([X]/[R]) RoundUp: -1*[R]*Int([X]/(-1*[R])) NoBankers: [R]*(Round(([X]+0.00001)/[R],0)) RESOURCES: ROUND Function Covered In: