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.