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

Copper Contributor

Hi,

 

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

 

Table1 fields are:

Machine_ID

Part_ID

QuantityInMachine

 

Table2 fields are:

Part_ID

Quantity

 

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,
Paul

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