delete duplicates

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

Guest

There are 28 pages on deleting duplicate records in help. Can I use one query
to delete dupliucate records (based on two fields) but keep one of the
duplicates? Make it simple please.
 
OK, I read the link. Does that take care of: let's say there a re three
duplicate records, and the append operation does not add x records. Does that
mean none of the three are added or two of three are not added?
 
The latter.

--
Brendan Reynolds
Access MVP

sierralightfoot said:
OK, I read the link. Does that take care of: let's say there a re three
duplicate records, and the append operation does not add x records. Does
that
mean none of the three are added or two of three are not added?
Click to expand...
 
Back
Top