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.

Here's a bunch of information on rounding techniques for Access:

http://www.yqcomputer.com/

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

--

Allen Browne - Microsoft MVP. Perth, Western Australia

Tips for Access users - http://www.yqcomputer.com/

Reply to group, rather than allenbrowne at mvps dot org.

http://www.yqcomputer.com/

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

--

Allen Browne - Microsoft MVP. Perth, Western Australia

Tips for Access users - http://www.yqcomputer.com/

Reply to group, rather than allenbrowne at mvps dot org.

2. Allocated amount rounded to nearest .25 without exceeding tota

3. Allocated amount rounded to nearest .25 without exceeding total

5. Round a number to the Nearest .25

6. Rounding to the nearest 25 including negative numbers??

7. Rounding up to nearest quarter, (:25, :50, :75, :00)

8. I am trying to round up to the nearest 25 cents

9. How do I round to the nearest 25 cents in Excel?

10. How do I tell a price list to round up and down to the nearest 25

11. How can I Round up to the nearest .25

12. Round up to nearest 25 or 50?

13. I need a formula with rounding up & rounding down to the nearest .

14. Rounding -- was [PHP] round to nearest 500?

15. [PATCH 0/25 -v2] paravirt_ops for x86_64, second round

4 post • Page:**1** of **1**