Last updated: August 26, 2026.
The Abs function returns the absolute, non-negative value of a number.
Syntax
Abs(number)| Argument | Description |
|---|---|
number | Numeric expression |
Examples
Abs(12.5) ' 12.5
Abs(-12.5) ' 12.5
Variance: Abs([Actual] - [Target])A Null argument returns Null. Abs changes only the sign; it does not round the value.
See Microsoft’s Access function reference for related expression functions.
