Re: INSERT INTO SELECT

[Jacque Scott]

OK, I found the answer.
 
CREATE TABLE ProductSums
SELECT DISTINCTROW IndenturedList.NSIPartNumber,
Sum(tblInvTransaction.Qty) AS SumOfQty
FROM IndenturedList;