Unique records

  • Thread starter Thread starter Andrea
  • Start date Start date
A

Andrea

I understand the unique values property, but how does the
unique records property work. I have tried to use it,
but without any luck. Can someone give me a query
example that would show how this property works?
 
Andrea

Underlying table with names and addresses.

More than one Smith at 1234 Elm St in the table.

Looking for unique addresses (not people) -- create a new query with only
[address] in display fields.

Set UniqueValues to Yes.

You'll only see unique versions of the addresses.

NOTE: if you have the following addresses that YOU think are matches,
Access WON'T:

1234 Elm
1234 Elm St
1234 Elm Street
1234 Elm St SW
 
Back
Top