Rounding to nearest .25

[Hanksor]

Is there something that will allow me to round decimals such as 0.14 to 0.25?
I know that Excel has a Ceiling function that works but I can't come up with
anything similar in Access. Any help will be appreciated.

 

[Michel Walsh]

- int(- 4 * x ) / 4



should do, for x >= 0



Vanderghast, Access MVP

 

[Allen Browne]

Here's a bunch of information on rounding techniques for Access:
http://allenbrowne.com/round.html

The section on rounding to the nearest 5 cents also has the 25c example.

 

[Hanksor]

Thank you very much. This helps a great deal........