By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,991 Members | 1,887 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,991 IT Pros & Developers. It's quick & easy.

find duplicate query- multiple fields

GrandMaster
P: 8
Hi all

I'm using MS Access 97 and in my current database (a flat single table database) I have a field for FirstName and one for FamilyName. I've been given two different lots of data to import but some have the same person repeated on both. The only difference is that there is another field that nominates which of the two batches of data that record is from. Therefore I need to make a find duplicate query which can find where both FirstName and FamilyName are the same and tell me the ID (which is the Autonumber) of both records so I can consolidate them into one.

Thanks for your help in advance.
Mar 21 '07 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,349
There's a find duplicates query wizard.
Mar 21 '07 #2

GrandMaster
P: 8
I should have explained that I didn't have that feature installed for some reason and I was hoping to find out how to do it manually.
I upgraded to Access 2003 anyway with the wizards so I've done it myself, thanks anyway.
Mar 22 '07 #3

Rabbit
Expert Mod 10K+
P: 12,349
Good luck.
Mar 22 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.