SQL•SQL References

MS Access Abs() Function

Example

SELECT Abs(-243.5) AS AbsNum;

Definition and Usage

The Abs() function returns the absolute (positive) value of a number.

Syntax

Abs(
number
)

Parameter	Description
number	Required. A numeric value

Works in:	From Access 2000

Loading lesson path

SQL•SQL References

Example

SELECT Abs(-243.5) AS AbsNum;

The Abs() function returns the absolute (positive) value of a number.

Syntax

Abs(
number
)

Parameter	Description
number	Required. A numeric value

Works in:	From Access 2000