FLOOR function

R

Rebecca

Can you use the FLOOR function in Access. It's in Excel
but I can't seem to find it in the Expression Builder in
Access.
 
J

JohnFol

This is the same as

? (int(number / significance) * significance)

To make life easy on yourself, just add a function to a module such as

Function Floor (number,significance)

Floor = (int(number / significance) * significance)

End Function

Alternatively, just add a reference to the Excel library and call any of
it's functions!
 
Top