Unique records

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?
 
J

Jeff Boyce

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
 
Top