Rounding up or down in Access 2003

[JohnELMI]

I have a column of data in a Access query that I would like to be able to
round up or down such as the round function in Excel does.

For example I would like to take (48) and have it round to (50) or (23
round to 20) in the same column of data.

Thanks

 

[Wayne-I-M]

Hi

Try this link
http://support.microsoft.com/kb/209996

 

[Guillermo_Lopez]

Hi

Try this linkhttp://support.microsoft.com/kb/209996

--
Wayne
Manchester, England.







- Show quoted text -

You can try this.
Rounded: Round([Field]/10)*10

This however would round up half of the numbers ending in 5 and round
down the other half. (35 -> 40, 45 -> 40).
If you want the traditional way. then do this:

Rounded: Round([Field]/10+0.0000001)*10

you need more significant zeros than possible decimal places.

- GL