I am working with MS Access 2007 and want to learn how I can remove duplicate entries from a table.



My table has two fields; one has markets, the second has products, and there are over a million rows of data. I now there are several thousand instances where one product appears twice in a given market.

Is there a way to query this table to eliminate all the duplicate entries within each market?

Thank you for any help.