Re: loop through records delete values that are equal
From: John Nurick (j.mapSoN.nurick_at_dial.pipex.com)
Date: 10/26/04
- Next message: ITMA: "Re: Understanding what makes Access tick"
- Previous message: John Nurick: "Re: What field names would you expect to find in a Telephone director."
- In reply to: Linda: "loop through records delete values that are equal"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 26 Oct 2004 22:18:49 +0100
Hi Linda,
For a one-off I feel it's simpler to create a new table with the same
structure and then use an update query that only adds unique records,
like this
INSERT INTO tblNew ( TheWord )
SELECT DISTINCT tblOld.TheWord
FROM tlbOld;
Then delete the old table and rename the new one to the name you need.
On Tue, 26 Oct 2004 07:55:03 -0700, "Linda"
<Linda@discussions.microsoft.com> wrote:
>I have a list of about 200,000 words (1 word per record) many of which are
>the same. Is there a way to loop through all of the records and delete any
>records that are duplicates?
-- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email.
- Next message: ITMA: "Re: Understanding what makes Access tick"
- Previous message: John Nurick: "Re: What field names would you expect to find in a Telephone director."
- In reply to: Linda: "loop through records delete values that are equal"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
