Rounding up or down in Access 2003


J

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
 
Ad

Advertisements

Ad

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top