Need Query Help from the experts !!!!

[zacharyjunior]

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.

 

[SteveA]

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