Returns the absolute value of a number.


Abs ( number )


number - any numeric expression or field containing a numeric expression

Data type returned 

number, time

Originated in version 

6.0 or earlier


The absolute value of a number is positive. For example, if a negative number appears in a field, the Abs function removes the minus sign and changes it to a positive value.

Example 1 

Abs(-123) returns 123.

Example 2 

Abs(PriceDifference) returns the positive value of the number in the PriceDifference field.

Example 3 

Abs(TargetDate - ActualDate) returns a positive value for the number of days difference between the values in TargetDate and ActualDate.