Access: Int Function
In Access, the Int function returns the integer portion of a number.
The syntax for the Int function is:
Int ( expression )
expression is a numeric expression whose integer portion is returned.
Note:
If the expression is negative, the Int function will return the first negative number that is less than or equal to the expression.
For example:
Int (210.67) would return 210 Int (2.98) would return 2 Int (-2.98) would return -3
VBA Code
The Int function can be used in VBA code. For example:
Dim LNumber As Double
LNumber = Int (210.67)
In this example, the variable called LNumber would now contain the value of 210.
SQL/Queries
You can also use the Int function in a query.
