Unique values property - doesn't work

Question

Hello,

I am using Access 2003. I have a query with the Unique Values Property set to Yes, but I am still getting duplicate records when I run my query. Any ideas?

Answer 1

The "UNIQUE"ness is defined over ALL the fields that are selected.

FirstName  LastName

Joe             Smith

Joe             Blow

respect uniqueness, even if there is two Joe, the WHOLE ROW, well, each of them, is UNIQUE.

Note also, that one is not l, and zero is not as capital o, even if, given some fonts, they LOOK the same. Same thing if a name has trailing spaces or un-printable characters (which may occur if the data is imported, much less likely if native to Access).

Answer 2

I have never heard of that failing.  Are you sure there are two records with the same value in every field?  If you are sure, post back with a Copy/Paste of the query's SQL view and I'll see if I can spot something.

Answer 3

Does the query start with SELECT DISTINCT in SQL view?  It should, so if not edit it and see what happens.

---

Ken Sheridan, Stafford, England