?
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
?
61 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 

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 46

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
 

Author Closing Comment

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

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
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 …
Suggested Courses

752 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