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

Deleting duplicates and keeping one unique record

Status
Not open for further replies.
csunsun

csunsun

Technical User
Apr 29, 2003
41
US
hi,

i want to find duplicate records in a table.

i want to keep one unique record and delete the duplicates...

i tried running a delete query, but the query deletes all of the records and does not keep one unique record...

and ideas?

thanks!

 
Sort by date Sort by votes
Have a look here: faq701-5721

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JimStrand
  • Locked
  • Question
Crosstab query - returning 1 record per week instead of 1 record
Replies
1
Views
278
JimStrand
JimStrand
datajockey123
  • Locked
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
282
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
141
Andrzejek
Andrzejek
accesshelp1
  • Locked
  • Question
How can I remove parenthesis and everything that comes after it? 1
Replies
3
Views
308
Andrzejek
Andrzejek
Wolfdzn
  • Locked
  • Question
Join two seperate SQL into one
Replies
6
Views
160
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top