Find Duplicates Not Working

[Adam McReynolds]

I have an issue where two fields are exactly the same but do not show as duplicates. I checked for empty spaces and next lines, which I know cause this problem but everything is fine. Has anyone come across this issue?

The original data in my database which I am trying to compare to was imported through Excel, and I am guessing this is the root of the problem. Any suggestions would be appreciated. Thanks.

 

[spikepl]

There are no miracles. So your issue has two possible explanations:

1. The content of the two fields is not the same. You could compare character by character to test.
2. Your test for duplicates is faulty. You have not shown how you compare, or whether you have tested the test elsewhere.

 

[jdraw]

Adam,

Please show us the data values or tests where you and Access disagree.
We need to see the query sql , the original data values and any results involved.