Indexed - Yes(NoDuplicates)

[Guest]

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.

 

[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!

 

[Jeff Boyce]

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

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[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]