Trying to sum a cloumn with a condition 1

[LyndonOHRC]

I am using a JetSQL/ODBC connection.

This query works but I need another column that is conditional. The column I need is Sum(Amount) Where Instrument='ACH' as ACHSales. But I don't know how to integrate that into the query.

Select Format(TransactionDate,'yyyy/mm/dd') as mTransactionDate, Track, Sum(Amount) as TotalSales, Instrument
	From Receipt
	Group By Format(TransactionDate,'yyyy/mm/dd'), Track
	Order By Format(TransactionDate,'yyyy/mm/dd') desc,Track

Thanks

Lyndon

---People Remember about 10% of what you say ---They never forget how you made them feel. Covey

 

[PHV]

Select Format(TransactionDate,'yyyy/mm/dd') as mTransactionDate, Track, Sum(Amount) as TotalSales, Instrument[!], Sum(IIf(Instrument='ACH',Amount,0)) AS ACHSales[/!]
From Receipt
Group By Format(TransactionDate,'yyyy/mm/dd'), Track
Order By Format(TransactionDate,'yyyy/mm/dd') desc,Tr

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[LyndonOHRC]

Thank you very much!

Lyndon

---People Remember about 10% of what you say ---They never forget how you made them feel. Covey