Filter repeated records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to filter out all the repeated records. I sorted it. I want to
know how to filter out all the records that have been shown in precious
records.

It is like Field 3
133 Emmet ST
133 Emmet ST
133 Emmet ST
500 5th ST
500 5th ST

to 133 Emmet ST
500 5th ST
 
Just create a select query, select all the fields and then
in query properties set unique values to True.
 
Back
Top