Query to get rid of duplicated records within a table.

  • Thread starter Thread starter Latifah
  • Start date Start date
L

Latifah

I'm looking for the criteria to put in a simple query on a
table that has duplicate records, to get rid of the
duplicate records. The distinct field to be used is the
Social Security Number. What is the criteria to put in
the design view of the query to do this?
 
I go about it sort of backwards ... I identify the record I want to keep ...
put a "mark" in a field for that record and then delete whatever record does
not have that mark. Roy
 
Back
Top