I have a table that is called QuoteItems. My users add individual items to a quote and an entry is added to the QuoteItems table. I want to write a query that will grad all items for an individual quote ID and calculate the quantity and extended cost. If you see my example tables below you can see that I have a table(first table) with all items in it. The second table is how I want my query to return data. i know how to get all the items for a single quote ID, what I want to be able to do is count count how many of each part number type I have and show only a single row for all fo them, then add the count to the qty colum and multiple that by the cost to get the extended cost. Any help is appreciated.
ManufactureID PartNumber Desc Cost QuoteID 1 x21 the new x21 12.00 1 1 x21 the new x21 12.00 1 2 y17 the new y17 14.00 1 2 y18 the old y18 22.00 2
ManufactureID Part Number Desc Cost Qty Ext Cost 1 x21 the new x21 12.00 2 24.00 2 y17 the new y17 14.00 1 14.00