Access Rounding Up to Nearest $5
Posted on 2013-06-11
I am trying to find a way to round up any given decimal or integer number to the nearest $5 or $0.
Example: $178.92 rounds up to $180, $199.01 rounds up to $200, $231 rounds up $235.
I am using Access 2000 and am trying to do this within an Access update query if possible. The built in rounding function cannot handle this as it will round down as well as up, I beleive. I have tried using the Int() function and get close, but there is always an exception that seems to fail.
I don't mind if I have to write a function, but it seems it should not be that difficult.