Last updated: August 26, 2026.
The Sgn function returns -1, 0, or 1 according to the sign of a number.
Syntax
Sgn(number)| Argument | Description |
|---|---|
number | Numeric expression |
Examples
Sgn(-12) ' -1
Sgn(0) ' 0
Sgn(12) ' 1A Null argument returns Null. Sgn reports direction only; it does not return the magnitude of the value.
See Microsoft’s Access function reference for related expression functions.
