In Access, the Abs funtion returns the absolute value of a number.
The syntax for the Abs function is:
Abs( number )
The argument number can be any valid numeric expression. If number contains Null, Null is returned. The absolute value of a number is its unsigned magnitude. For example, ABS(-1) and ABS(1) both return 1.
Example
Abs (-1.45) returns 1,45 Abs (2.17) returns 2,17
VBA Code
Dim MyNumber MyNumber = Abs(42.7) MyNumber = Abs(-42.7)
This example uses the Abs function to compute the absolute value of a number. Now the MyNumber variable would contain the value 42.7.
SQL query
You can also use the Abs function in a query.
SELECT Abs([Salary]) AS Expr1 FROM EmployeeStatisticsTable