Combining records (1 Viewer)

S

Steve1445

Guest
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.
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 09:41
Joined
Feb 28, 2001
Messages
27,003
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.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 10:41
Joined
Feb 19, 2002
Messages
42,984
Post a couple sample records of what you have and what you want.
 

Users who are viewing this thread

Top Bottom