How can I carry a balance over from a previous entry?


I have a debit and credit field, and in the balance field of the query I have "Balance:[credit]-[Debit]"

it works for the first entry but does not carry forward, the next totals are negative values.


:confused: thanks for any help.