Hi,
How can I update a table field by a calculated field (from a query) using an update query? To simplify the problem;
Lets say I have 2 tables:
1- tblParts;
Part BalanceOnHand
A 10
B 20
C 30
2- tblTransaction;
ID Part QTY Trans
1 A 1 Receive
2 B 2 Transfer
3 C 3 Transfer
4 B 4 Receive
5 C 5 Transfer
6 C 6 Receive
for each part, the Qty Transferred should be deducted from received and the result should be updated in tblParts.
As a result at the end my tblParts should look like this:
Part BalanceOnHand
A 11
B 22
C 28
thanks,
Amir