duplicate records with extra info

C

cheesewizz76

Hi all,

OK this is what I am trying to do. I have duplicate records (in the phone #
field) and I want to delete those records. But some of them have different
information in some fields (ie they have the same last name but a different
first name...or they have same last name different first name and different
address). I want to delete the double phone # but somehow keep the different
information (i.e. add the different first name to the other first name).
Also...I am not very knowledgable about VBA code so if you could explain it
in another way or in steps that would be great.

Val

PS I hope this makes sense????
 
C

cheesewizz76

OK Hope this explains it a little better

what I have…
Phone ID Fname Lname
204-637-2465 7067 Eddie Maendel
204-637-2465 7066 B Maendel
204-658-3333 7418 Dave Gervin
204-658-3333 7417 Cal Gervin
204-658-3425 12149 Dave Stewarts
204-658-3425 7422 Duncan Stewart
204-736-2622 6888 Stuart Manness
204-736-2622 6890 Sidney Manness
204-736-2622 6889 Donald Manness
204-745-2273 6901 Robt Mcintosh
204-745-2273 6877
204-746-6559 6989 Mike Maendel
204-746-6559 6966 J Maendel
204-746-6559 6990 Micheal Maendel
204-757-4874 6819 David Hofer
204-757-4874 6817 Josua Hofer
204-764-2126 7395 Albert Waldner
204-764-2126 7414 Michael Waldner
204-764-2126 7416 Peter Waldner
204-764-2126 7415 Jacob Waldner
204-829-3551 6902 Wayne Nickel

What I want…
Phone ID Fname Lname
204-637-2465 7067 Eddie & B Maendel
204-658-3333 7418 Dave & Cal Gervin
204-658-3425 12149 Dave & Duncan Stewarts
204-736-2622 6888 Stuart & Sidney & Donald Manness
204-745-2273 6901 Robt Mcintosh
204-746-6559 6989 Mike & J Maendel
204-757-4874 6819 David & Joshua Hofer
204-764-2126 7395 Albert & Michael & Peter & Jacob Waldner
204-829-3551 6902 Wayne Nickel

But remember...I have more fields (like Address1, Address2, Town...) that
have additional info....

Please Help!!!!
 
Top