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.