Query to divide numbers from one table by another, and insert into a third

[jcuoco78]

Hello,

I have an Access database that I am creating that I need to take values from multiple tables and divide one by another then insert it into a third table. All three tables have a column for part number which will be the driver. I need to take the value of the week column from table1 and divide it by footage column in table2, then insert it into the week column in table3.

So for example, I have part number 123 where I have 30,000 in the week column of table1, 300 in the footage column in table2. I need to enter the value 100 into table 3 in the row that matches the part number 123. I have been able to do this with a single part number but I want the query to loop through every line and update all of them without having to enter every part number 1 by 1. Is there a way to do this?

 

[stumac]

I would be pretty worried if you expect 44 rows to update and it's updating 110. It probably means table3 contains duplicate part numbers... The query will update all of them. You maybe want to include a where clause to exclude records that already have a value in the week field.