I have a Database that contains about 24,000 or more records. The Database has about 15 columns. I would like to select an entire row that does not contain duplicates based on two columns. I would also like to add the totals of the columns it finds to be distinct.
Example:
Column1 = accountno
Column2 = bankno
Column3 = custname
Column4 = address
Column5 = phoneno
Column6 = taxid
Column7 = saleamount
Column8 = fees
I would like to combine records whose custname and taxid are the same and add their saleamount and fees to create one entry.
