TOTALS

[ARTHUR]

IM TRYING TO BUILD AN EXPRESSION TO RETRIEVE TOTALS. HERES MY DELEMA I HAVE A
FIELD IN MY TABLE CALLED "CHARGES" THAT HAS NEGATIVE AND POSITIVE AMOUNTS, I
WANT TO RUN A QUERIE THAT WILL RETRIEVE THE TOTAL OF THE NEGATIVE AMOUNTS
ONLY. WHAT IS THE CORRECT STRING. THANK YOU

 

[Patrick Stubbin]

use an iif expression
select sum(iif(charges<0,charges*-1,0)) from yourtable;

 

[Ofer]

Try this:
SELECT Sum(CHARGES) AS SumOFCHARGES
FROM TableName
WHERE CHARGES<0