Combining data

[joshynaresh]

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 me how can I do. Thank YouSuppose 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 me how can I do. Thank You

[June7]

It is possible but saving calculated data is usually a bad idea, especially aggregate data. Calculate when needed.