Access Function like Excel Mround function?

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

 

[KARL DEWEY]

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

 

[John W. Vinson]

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!

Not builtin but you can work out your own:

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

should do it.

 

[Faye]

Thanks Karl...that worked perfectly!

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

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!