ansaurus

Question

Answer 1

+4 A:

select Account, 
    sum(case when Type='D' then Amount * -1 else Amount end) as AmountSum
from Payment
group by Account

RedFilter 2010-08-18 21:16:47

Works perfectly. Thanks

James Ramos 2010-08-18 21:36:58

@James - In that case you should select the tick mark to the left of this answer to mark it as the accepted answer.

Martin Smith 2010-08-19 12:27:06

Help creating a single SELECT statement for SQL Reports