SELECT CustomerID, SUM(UnitCost*Qty) As Value INTO TABLE MyResult Group By CustomerId, Order By ID.