Merging and selecting dupes - URGENT

[cds35]

I have multiple databases. I wanted to merge them, so I did a copy of the stracture of the database then did an append query into that structure. This elimated the dupes because of the primary key. My question is how can I tell Access which duplicate I want to keep and which one to discard, because some records have more than others. For example:

Jon Smith jsmith@aol.com United States
Jon Smith jsmith@aol.com 123 Main Street Anytown, NY, 22525

How do I tell access that I want the second record to be kept b/c it has more usable information

 

[larryww]

There's not enough info in your question to answer that...but, can you get the duplicate "keepers" in one table, to be augmented by nonduplicates? Then append to THAT, and it will reject the duplicate "NONkeepers." Right?