INSERT INTO SELECT

[Jacque Scott]

Table ProductSums has not been created.  Can you create this table when
you insert data into it? 
 
INSERT INTO ProductSums
SELECT DISTINCTROW IndenturedList.NSIPartNumber,
Sum(tblInvTransaction.Qty) AS SumOfQty
FROM IndenturedList;