Access Query - two linked tables, how to copy value from one table to the other?

Copper Contributor



I have two tables in Microsoft Access with the following fields:


Table1 fields are:





Table2 fields are:




For every Part_ID value in Table1, there is a matching record in Table2 that has the same value for Part_ID.  I am able to create a SELECT query that does an inner join between the tables on Part_ID.  When I do this, for every Part_ID, I see the Table1.QuantityInMachine field and the the Table2.Quantity field for every Part_ID. 


I'd like to somehow modify this query so that for every record (every Part_ID) returned by the query, it will copy the value in Table2.Quantity to Table1.QuantityInMachine.


I have not been able to figure out how to do this.  If anyone here can give me a clue, I would greatly appreciate it.

Thanks and best regards,

1 Reply
Replied to on Answers, with a request for complete table structures to work with.