Wow! quick replies! Heart felt thanks friends

I have arrived at the query i needed

SELECT TransDate,

SUM(CASE WHEN TransName='Deposit' THEN Amount ELSE 0 END) as TotalDeposits,

SUM(CASE WHEN TransName='Withdraw'...