Access Function like Excel Mround function?

  • Thread starter Thread starter Faye
  • Start date Start date
F

Faye

I need to round either up or down to the nearest quarter. Is there a
function in access that works like Mround in excel where I can pass it the
number and .25? Thanks for any insight!
 
I need to round either up or down to the nearest quarter. Is there a
function in access that works like Mround in excel where I can pass it the
number and .25? Thanks for any insight!
Click to expand...

Not builtin but you can work out your own:

Round([number]*4, 0)/4.

should do it.
 
Thanks Karl...that worked perfectly!

KARL DEWEY said:
Try this --
To the quarter: Int(4*[Cost]+0.5)/4


Faye said:
I need to round either up or down to the nearest quarter. Is there a
function in access that works like Mround in excel where I can pass it the
number and .25? Thanks for any insight!
Click to expand...
Click to expand...
 
Back
Top