Link to home
Start Free TrialLog in
Avatar of Dustin Stanley
Dustin Stanley

asked on

MS Access Find Duplicates In Combined Unique Fields When Trying To Set A Unique Index In A Table

In my "SKUs" Table I have two fields I want to make as a combined Unique Index.
These two fields are "ManuID" and "SkuMPN"
Manufacture and Manufacture Part Number

When I try this it errors and says there are duplicates that need to be removed first.

I have 1000's of Records so how can this go easy weeding the duplicates out?

THANK YOU!
Avatar of Dustin Stanley
Dustin Stanley

ASKER

Just an Update I believe some of the MPN (SkuMPN) field is empty and this is why the error occurs. Is there a way around this?
ASKER CERTIFIED SOLUTION
Avatar of aikimark
aikimark
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
That's what I thought Thanks!