Ok so I have a database for quoting items. I have a tblQuote and a tblQuoteItems. I created a form that allows me to add a quote to the tblquote and items to the tblQuoteitems. This all works great. When I print out a report of of the records in tblQuoteItems for a particular quoteID. This works great too. What I want to do is evaluate the items in tblQuoteItems and total up any the items
example currently my subform shows as an example"
Name Desc Cost
Product A a desc about me 50.00
Product A a desc about me 50.00
Product A a desc about me 50.00
Product B a desc about me 25.00
Product B a desc about me 25.00
what I want to show
Name Desc Cost Quantity Ext Cost
Product A a desc about me 50.00 3 150
Product B a desc about me 25.00 2 50
I cant change the tblQuoteItems to the format needed because each item may have data tagged to them(SN,PO etc). I just need to summarize it for the report that prints out. Any ideas? Thanks in advance.