Hi Russell

Thank you for the reply.

Wouldn't the select command that you sent create a table called myresult with all the fields in the customer table plus the value field created with as value?

If so wouldn't this be the long way of doing the same thing as creating a field on the report to do this?

Or is there an other reason for this?

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