I am trying to sum the totalCost of each productName from this query (this shows all entries for Hot Like Me):
in the qryBatchCost query:
But as you can see, the total it gives me is much higher than it should be. I cannot see why.
Built with the query designed, but for reference, the SQL:
Code:SELECT qryCostingPerOz.productName, Sum(qryCostingPerOz.totalCost) AS SumOftotalCostFROM tblMaterials, qryCostingPerOz GROUP BY qryCostingPerOz.productName;