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
29 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
 

Author Comment

by:Dustin Stanley
Comment Utility
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 45

Accepted Solution

by:
aikimark earned 500 total points
Comment Utility
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
 

Author Closing Comment

by:Dustin Stanley
Comment Utility
That's what I thought Thanks!
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now