Suppose I have two table.
1. LimitTable
AccNo Name OutstandingBal 071 Naresh 072 Ranjan
2. TxnTable
AccNo Debit Credit 071 5000 3000 072 3000 2000 071 10000 8000 072 5000 3000
I Want to Update LimitTable as
3. LimitTable
AccNo Name OutstandingBal 071 Naresh 4000 072 Ranjan 3000
Note: (Debit-Credit) of same account
Is it possible in access 2007?
Please help in detail with query/code to me how can I do. Thanking You in advance.