Payment Deposit Balance Should be --------------------- --------------------- ---------- ------------ 750.00 750.00 750.00 18.52 18.52 731.48 74.28 74.28 657.20 42.16 42.16 615.04 100.00 100.00 515.04 NULL 150.00 150.00 665.04 112.25 112.25 552.79>>I'm not sure if I'm explaing what I want. This query does not return the results I want:
>>Payment Deposit Reconciled Balance >>--------------------- --------------------- ---------- ------------ >>NULL 750.00 NULL 750.00 >>18.52 NULL NULL 18.52 >>74.28 NULL NULL 74.28 >>42.16 NULL NULL 42.16 >>100.00 NULL NULL 100.00 >>NULL 150.00 NULL 150.00 >>112.25 NULL NULL 112.25 >>>>