Rounding to the nearest hundred in Access

[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.

 

[Allen Browne]

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]...