round values to the next multiple of 5

[Sudha]

Hi,
How do I round values to the next multiple of 5, but if the value is a multiple of 5 then it should return the same value.

 

[MSAccessRookie]

Hi,
How do I round values to the next multiple of 5, but if the value is a multiple of 5 then it should return the same value.

Using an IIf Statement can do this. Something like:

SELECT IIf ([value]/5=int([value]/5), [value], (int([value]/5)+1)*5)
from YourTable;

 

[ByteMyzer]

Another way would be a non-conditional expression, like the following:

SELECT Int( MyTable.MyValueField / -5 ) * -5
FROM MyTable;