Delete Duplicate Values

[Mary]

I have a Find duplicages query with hundreds of duplicate
values. I want to delete all duplicates. Is there a
quick way to do this?

 

[Allen Browne]

Not really.

Simplest idea is to create a query that generates the non-duplicated data.
Turn it into a MakeTable query (Make Table on Query menu).
Run it, and then delete the original table.

 

[Mary]

Thanks so much! I've been going about it the wrong way!
Mary