How do I separate duplicates to a separate table?

I am trying to take all records that have a duplicate in a particular column and put them in a separate table. Is this possible? Please help with any ideas. Thanks.
bemara57Asked:
Who is Participating?
 
DoubleJ92Connect With a Mentor Commented:
Use Access's find duplicates query wizard and then change the query type to a make table query.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Do you mean you are moving the entire record to another table? You can do using several methods; for example, you can use a SQL Insert command:

Currentdb.Exectue "INSERT INTO SomeTable(Col1, Col2, Col3) VALUES(SELECT Val1, Val2, Val3 FROM AnotherTable WHERE YourColumn=YourDuplicateValue)"

0
 
bemara57Author Commented:
Wow DoubleJ92, that built in feature is off the chain! Pls excuse the slang, I'm just excited b/c that just saved me hours of work. Thanks!
0
 
DoubleJ92Commented:
No problem. Glad I could help :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.