Rounding to the nearest hundred in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to round to the nearest hundred in a query, i.e., 23,345 to
23,300. I entered the following expression: round([Low Guideline],-2). The
query runs, but produces "# ERROR" in this field. Any suggestions would be
greatly appreciated. Thanks.
 
Unfortunately, the Round() function built into Access does not accept
negative powers of 10.

Copy the custom function from:
http://www.mvps.org/access/modules/mdl0054.htm

Be sure to rename it so it does not fight with the built-in one.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

in message
news:[email protected]...
 
You must log in or register to reply here.

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

Rounding to the nearest hundred 2
Preventing rounding numbers to nearest dollar 2
Rounding up to the nearest .25 1
Access 2007: % fields rounding to nearest integer 3
Rounding up! 2
Round to nearest quarter 5
Round to nearest 10,000 2
Round to a Multiple 2

Back
Top