rounding to nearest 5000

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

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.
 
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?
 
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
..
 
looks like it works.
thanks very much!

John Spencer said:
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
..

confused said:
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?
Click to expand...
Click to expand...
 
Back
Top