absolute value in access query

[Jacki]

How do I get a result that is an absoute value in a query?

 

[Albert D. Kallal]

You can use the abs function.

So,

select Customer, abs([Payments]) as churnRate from tblCustomers


Simply put, abs returns a positive value for any given negative number...