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

Moving Record Duplicates

gregoryt2002
P: 13
I need to search one of my database tables and move all the duplicate records into a new table.

Is there an easy query to do this?

Thanks

Tom
May 21 '07 #1
Share this Question
Share on Google+
3 Replies

Rabbit
Expert Mod 10K+
P: 12,441
I need to search one of my database tables and move all the duplicate records into a new table.

Is there an easy query to do this?

Thanks

Tom
You can't really move a record, you'll have to do an append and delete and maybe another 2 appends depending on what you want.
May 21 '07 #2

gregoryt2002
P: 13
You can't really move a record, you'll have to do an append and delete and maybe another 2 appends depending on what you want.
I currently have a table called 'Attendees' which contains duplicate records. Due to the fact I imported the information from lots of spreadsheets there is duplicate names but that does that mean that the rest of the information for the record is duplicated. Hope that makes sense.

I want to do a query to filter all the dupliacte records into a new table so that I can then check what info it present for the duplicates and delete as necessary.
May 21 '07 #3

Rabbit
Expert Mod 10K+
P: 12,441
There's a query wizard to find duplicate records.
May 21 '07 #4

Post your reply

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