Int
Using the Int Function
In this tutorial you will learn how to use the Int Function.
The Int function returns the integer portion of a number.
=Int( number )
number any valid number expression
Int returns the first negative integer less than or equal to number. For example, Int converts -8.4 to -9
In this example we will use 99.8.
The result is 99.
Query
The results using a Query would be
SELECT Int(99.8);
FORM
In a Form you could set the Default Value of a Textbox to
=Int(99.8)
VBA
In a Form add a TEXTBOX control and rename it "txtInt", then you could add the following in the Load Event.
Private Sub Form_Load()
txtInt = Int(99.8)
End Sub
Courses
Access Expert 26
Tips
See this FREE Tip on Int, Round and Fix.
Search
You can find more about this by searching the website.
By: Alex Hedley
Click here to sign up for more FREE tips
|