Access 2007: Simple math with fields

[Art W.]

Hello Everyone:

I am trying to add and subtract fields from one another. I have fields called Balance, Debit and Credit. How do I get the balance to equal balance minus debit plus credit as a running total in my table? Just think of it as a check book. Please be specific on how to do this?

If this can’t be done what can I do?

Thanks

Art W.

[incidentals]

colum a credit
colimn b debit

totalcredit cell = sum(column a)
totaldebit cell = sum(column b)

balance = totalcredit cell - totaldebit cell

you should be able to workout what to do from that

if you can't you will need to create a small example excell and post it so that we can put the absolute code in for you!

here to talk

[westconn1]

balance is normally opening balance - sum all debits + sum all credits, not per transaction