>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
>

>
>The last column should be have the balance, not the value of the despoit or payment column.

How the balance should be calculated?

Can you post some sample data and what exactly do you want to get?