Access: Abs Function
In Access, the Abs function returns the absolute value of a number.
The syntax for the Abs function is:
Abs ( number )
number is a numeric value.
For example:
Abs (-210.67) would return 210.67 Abs (-2.9) would return 2.9 Abs (-3) would return -3
VBA Code
The Abs function can be used in VBA code. For example:
Dim LNumber As Double
LNumber = Abs (-210.6)
In this example, the variable called LNumber would now contain the value of 210.6.
SQL/Queries
You can also use the Abs function in a query.
