Hi Richard

I have been doing the Access course with you at 599cd which is helpful. I have a question.

I have a table that I have imported from an excell sheet. Only 2 fields. (Stock code and Suppliers part number.
The data came in well but I have duplicates which I want to sort out. (there are a lot of records in this table.) and generally only one or two duplicates for each entry, if any,
Some are a 100% duplicate (eg stock code and Suppliers pat number) and others have the same stock code but no suppliers part number. I want to keep the record with the most amount of information, Eg both stockcode and suppliers part number. Eventually I want to make a new table out of the sort.
I was thinking of using a query or a macro but not sure how to go about it. Can you point me in the best way to do it? Thanks Richard.