MS Access Abs() Function
The Abs() function in MS Access calculates the absolute value of a number. The absolute value is always non-negative (positive or zero), representing the magnitude of the number without its sign.
Abs(): Definition and Usage
Abs() is a very useful mathematical function for situations where you only need the magnitude of a number and not its sign (positive or negative). This is common in calculations or comparisons where the direction (positive or negative) is irrelevant; you are only interested in the size or distance from zero.
Syntax
Syntax
Abs(number)
Parameter Values
| Parameter | Description |
|---|---|
number |
The number for which you want to find the absolute value. This is required and must be a numeric value. |
Example
Calculating the Absolute Value
This example demonstrates how to use the Abs() function to get the absolute value of -243.5.
Syntax
SELECT Abs(-243.5) AS AbsNum;
Output
AbsNum
-------
243.5