I have spent countless hours researching this issue and have found nothing that works.
I have data in one table that has duplicate records... they aren't duplicate in the usual sense though, I need to sum the quantity field in those duplicates and make it one record.
For example,
PK Fields -...