MS Access Abs() Function
ExampleGet your own SQL Server
Return the absolute value of a number:
SELECT Abs(-243.5) AS AbsNum;
Try it Yourself »
Definition and Usage
The Abs() function returns the absolute (positive) value of a number.
Syntax
Abs(number)
Parameter Values
Parameter | Description |
---|---|
number | Required. A numeric value |
Technical Details
Works in: | From Access 2000 |
---|