I get several lists with inventory from my suppliers. I import the excel files into an access database. Multiple suppliers list the same inventory from the same manufacturer. I need a query to eliminate the duplicates.
I have 5 columns:
Part, MFG, Available, Vendor, Cost, Datecode, Package, Listdate.
If 2 or more rows have the same Part, Mfg, and Available, I only want to keep one row. It does not matter which one is kept.
I have tried DISTICT in the select on a make table query, but I need to copy all columns.
Thanks!
I have 5 columns:
Part, MFG, Available, Vendor, Cost, Datecode, Package, Listdate.
If 2 or more rows have the same Part, Mfg, and Available, I only want to keep one row. It does not matter which one is kept.
I have tried DISTICT in the select on a make table query, but I need to copy all columns.
Thanks!