Indexed - Yes(NoDuplicates)

Z

Zanstemic

I have a table that is already populated and I need to ensure the field does
not have duplicates. When changing the field to be Indexed with no
duplicates, it comes back with an error:

"would create duplicate values in index, primary key or relationship"

I've visually looked for duplicates in the field but can't seem to find any
duplicate numbers.

Any suggestions on how to check for duplicates or what else could be causing
the error.

Thanks in advance for the help.
 
F

Fred Boer

Dear Zanstemic:

Please forgive me if this is obvious, but it's worth a try:

Is there a number in every record in the indexed field? Are there any
blank/empty fields? Two blank fields would be a duplication...

Cheers!
 
J

Jeff Boyce

Use the query wizard to build a "duplicates" query.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
J

John W. Vinson

I've visually looked for duplicates in the field but can't seem to find any
duplicate numbers.

Run the Duplicates Query Wizard - it is much less likely to get bored looking
for dups than you are! It'll find some, I'm sure.

John W. Vinson [MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top