SELECT [Order Details].ProductID, Sum([Order Details].QuantityCases) AS QOH, Inventory.LBsPerCase*[Order Details].QuantityCases AS totWeight, Inventory.IngredientName
FROM Inventory INNER JOIN [Order Details] ON Inventory.ProductID = [Order Details].ProductID
GROUP BY [Order Details].ProductID...