How do I get a result that is an absoute value in a query?
A Albert D. Kallal Sep 7, 2003 #2 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...
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...
