• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 206
  • Last Modified:

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.
0
bemara57
Asked:
bemara57
  • 2
1 Solution
 
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
 
DoubleJ92Commented:
Use Access's find duplicates query wizard and then change the query type to a make table query.
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

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now