subquery

[Sam]

I'm trying to run a query on the above table to eliminate the duplicates.


Even if 1 out of the 3 fields is unique, it should be listed. Only if all 3 are duplicates, it need not be in the list.
I have tried the DISTINCT, WHERE and GROUP BY statements. Alas, no success.

[Sam]

Well, I could manage that by removing the ID field and setting the Properties - Unique Values to Yes.

[Micron]

Don't think I'd do that if you're talking about prevention. The best prevention would be a composite index (probably 3 fields, not including ID autonumber if that's what you have).
As for removal, try using the Find Duplicates query wizard to create a base query of dupes that you can delete from. If memory serves, you leave out the ID field in such a query.