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.
PK Fields - Store#, Item#
non-PK Fields - Description, Qty
Right now, the way the data is available (via excel files) there are multiple records of the same item from the same store with different Qty's that need to be summed together to get the true value.
In MS SQL I could very easily write some T-SQL that does something that basically says... If exists Update... else insert
The problem: Jet SQL is neutered. I can not find ANYTHING that can get this done.
I will love forever the person that can help me with this.