I have a table that has semi-duplicate records. 6 out of 7 fields has exactly the same information. I want to compare between records, loose the duplicate info, and concatenate the 7th field in the one record left from the dupe delete.

Sounds like you have some VBA code in front of you, perhaps.

I would have suggested using DLookup and string concatenation, but what bothers me is the complexity involved in writing an Update query if there are THREE duplicates. Access is good, but without VBA I would have no idea how to manage this reliably.

Post a couple sample records of what you have and what you want.