Duplicate Records

  • Thread starter Thread starter Edgar
  • Start date Start date
E

Edgar

Hi

I am new to Access and have created a db which
unfortunately has some duplicate records in it.

The table that these are in is called 'Prices'. I can run
the duplicate records query but I do not know how to
delete these duplicate records.

Can anyone help?

TIA
 
HI,


If the records are the same for every fields, it is preferable to
"insert" the records in a new table that does not accept duplicated values
( some records won't be append, that is ok, that is what we want).


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top