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!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: AeolusUmbra
- Order by date
-
Efficient Jet SQL for removing duplicate records?
> My apologies for trying to show you a better way. You make all sorts of amateurish assumptions, such as that the duplicate records in the table were unwanted to begin with, instead of being accumulated for counting purposes. And you assume that I have control over the DB tables, instead of...- AeolusUmbra
- Post #9
- Forum: Microsoft: Access Queries and JET SQL
-
Efficient Jet SQL for removing duplicate records?
> Deleting records <> manipulating date? please explain Well this is fundamental: I posted a question asking for a Jet SQL statement that will remove duplicate records from a database table. Another poster suggested changing the table itself instead, which is clearly a move in the wrong...- AeolusUmbra
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Efficient Jet SQL for removing duplicate records?
> Put an index on the table Thanks, but that would be manipulating shared tables, which is definately a no-no. I'm looking for a answer that only involves manipulating the data.- AeolusUmbra
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Efficient Jet SQL for removing duplicate records?
What is the most efficient way to remove duplicate records from a table using Jet SQL? I want to delete redundant records, keeping only one copy of each. Currently I SELECT using a GROUP BY and HAVING COUNT(*)>1, and then I interate through in DAO, deleting redundancies. Is there some better...- AeolusUmbra
- Thread
- Replies: 11
- Forum: Microsoft: Access Queries and JET SQL
