rounding to nearest 5000

[Guest]

How can I round to the nearest 5000 in an Access report?
I have a text box where I caclulate a number and I want to round my
calculated result to the nearest 5000. I was expecting to find a function in
Access similar to MROUND in Excel.
Thanks in advance for any help you can offer.

 

[zwestbrook]

How can I round to the nearest 5000 in an Access report?
I have a text box where I caclulate a number and I want to round my
calculated result to the nearest 5000. I was expecting to find a function in
Access similar to MROUND in Excel.
Thanks in advance for any help you can offer.

Try http://support.microsoft.com/default.aspx?scid=kb;en-us;209996

 

[Guest]

Thanks zwestbrook but it looks like that procedure will round up to the
nearest increment or round down to the nearest increment based on a variable
I supply. I was hoping that there was a formula or expression I could put in
the porperties of the text box in my report that would round to the nearest
5000 (i.e. 7499 to 5000, 7500 to 10000) without the extra input.
Any thoughts?

 

[John Spencer]

NOT FULLY TESTED

Round([YourNumber]/ 5000,0) * 5000

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

looks like it works.
thanks very much!

NOT FULLY TESTED

Round([YourNumber]/ 5000,0) * 5000

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Thanks zwestbrook but it looks like that procedure will round up to the
nearest increment or round down to the nearest increment based on a
variable
I supply. I was hoping that there was a formula or expression I could put
in
the porperties of the text box in my report that would round to the
nearest
5000 (i.e. 7499 to 5000, 7500 to 10000) without the extra input.
Any thoughts?