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