Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Duplicates moved to seperate table

Status
Not open for further replies.
badger8

badger8

MIS
Aug 3, 2001
34
US
I would like to find all duplicates and move only the first instance of two similar records to a duplicate table.

What query or code will I need to do this?

Thanks
 
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Delete From Table
Replies
1
Views
242
Andrzejek
Andrzejek
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
319
lameid
lameid
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
127
Andrzejek
Andrzejek
Wolfdzn
  • Locked
  • Question
Join two seperate SQL into one
Replies
6
Views
143
dhookom
dhookom
btamsgn
  • Locked
  • Question
how to create a crosstab query 1
Replies
1
Views
319
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top