Abs
Using the Abs Function
In this tutorial you will learn how to use the Abs Function.
The Abs function returns a value of the same type that is passed to it specifying the absolute value of a number.
=Abs( number )
number any valid number expression
In this example we will use -1.
The result is 1.
 Query
The results using a Query would be
SELECT Abs(-1);
 FORM
In a Form you could set the Default Value of a Textbox to
=Abs(-1)
 VBA
In a Form add a TEXTBOX control and rename it "txtAbs", then you could add the following in the Load Event.
Private Sub Form_Load()
txtAbs = Abs(-1)
End Sub
Courses
Access Expert 26
Seminars
SQL 2
 Search
You can find more about this by searching the website.
By: Alex Hedley
Click here to sign up for more FREE tips
| 
