loop through records delete values that are equal

[Linda]

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]

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.