R Rebecca Jan 5, 2004 #1 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.
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 Jan 5, 2004 #2 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!
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!
