Running Balance

[Shawn]

I'd like to create a running balance that basically should
say =[Balance]-[Debit]+[Credit]. When I put in that
formula nothing comes up. I can put in the formula =
[Balance]-[Debit] or =[Balance]+[Credit], but I need to
have both in order to get a true balance.

Any ideas?

 

[[MVP] S.Clark]

Running balances are not easy, because there's no simple way for Access to
know to use "the record before this one".

Thus, your values need to be the Sum of Total Balance, + Sum of All Credit -
Sum of All Debits.