Improve company productivity with a Business Account.Sign Up

x
?
Solved

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

Posted on 2016-10-13
3
Medium Priority
?
72 Views
Last Modified: 2016-10-13
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
Comment
Question by:Dustin Stanley
  • 2
3 Comments
 
LVL 1

Author Comment

by:Dustin Stanley
ID: 41842936
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
 
LVL 47

Accepted Solution

by:
aikimark earned 2000 total points
ID: 41842989
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
 
LVL 1

Author Closing Comment

by:Dustin Stanley
ID: 41842991
That's what I thought Thanks!
0

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Audit trails are very important in any system to hold people responsible for certain transactions and hold them to take ownership of their actions. This article is dedicated to all novice "Microsoft Access" developers.
Viewers will learn how the fundamental information of how to create a table.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question