<div>
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:<br />
<br />
Currentdb.Exectue &quot;INSERT INTO SomeTable(Col1, Col2, Col3) VALUES(SELECT Val1, Val2, Val3 FROM AnotherTable WHERE YourColumn=YourDuplicateVa<wbr />lue)&quot;<br />
<br />

</div>


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)"



<div>
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!
</div>


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!

<div>
No problem. Glad I could help :)
</div>


<div>
<div class="content wysiwyg-content">
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.
</div>
</div>


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.

How do I separate duplicates to a separate table?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.