The table has 3 columns:
depositamout (decimal)
trantype char(3) - can be 'DEP' (deposit) or 'CPU' (carrier pickup)
trandate datetime

I want to write a query that returns the the date associated with the carrier pickup and the sum of the deposits that occurred since the date of the previous carrier pickup, including those of the carrier pickup date.

Any help greatly appreciated.