Here is my problem. I have a query that is based off my customer complaint table. I want the query to return all the complaints and cost associated with the complaint. It does this. The problem is, is that when I place an order I may order 10 diffrent part numbers. In the query results it shows each individual part ordered and the cost. I want the query to summerize or put the complaint with the cost only and not duplicate each record.

In your query, ensure that the only field from the parts table is the cost field and that it has a total property of Sum. Bring up the properties window of the query and change the UniqueValues property to Yes and the UniqueRecords property to No.

HTH,
Steve A http://www.access-programmers.co.uk/ubb/smile.gif