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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with deleting duplicate records....

Status
Not open for further replies.
3Mark3

3Mark3

Technical User
Nov 30, 2005
48
US
Good morning everyone,
I have a question I hope someone can help me with. I would like to delete any duplicates in a query. Now I understand I can use the "find duplicates" query to identify, however if I were to delete those records, woudln't that also delete all instances?

How would I go about deleting the 2nd, 3rd, etc. instances of the records?
 
Sort by date Sort by votes
Look at PHV's post in thread701-1145120

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Question
Help with a Query. 1
Replies
13
Views
420
strongm
strongm
BugZap13
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
222
mikrom
mikrom
datajockey123
  • Locked
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
594
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
291
Andrzejek
Andrzejek
serino
  • Locked
  • Question
Delete with WHERE Clause. 2
Replies
4
Views
588
serino
serino

Part and Inventory Search

Sponsor

Back
Top