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

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...