• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 70
  • Last Modified:

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!
0
Dustin Stanley
Asked:
Dustin Stanley
  • 2
1 Solution
 
Dustin StanleyEntrepreneurAuthor Commented:
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?
0
 
aikimarkCommented:
If you have duplicates, whether the values are 'empty' or not, you will not be able to create a unique index.  You will need to resolve this issue first.
0
 
Dustin StanleyEntrepreneurAuthor Commented:
That's what I thought Thanks!
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now