You probably can make a query that builds another table, selecting everything
from your table, but not duplicated rows
SELECT DISTINCT MyTable.* INTO NewTable FROM MyTable;
Then tou can make two consecutive queries such as :
delete * from MyTable;
insert into MyTable (select * from NewTable)
Check the syntax before running this, my SQL is influenced by Oracle
If MyTable has links with other tables it will be a little more difficult, ask
for more
GC
________________________________
De : [email protected] [mailto:[EMAIL PROTECTED] De la part de
John Young
Envoyé : jeudi 26 juin 2008 11:48
À : [email protected]
Objet : [ms_access] duplicate records in table
G'day to all
I am new to this group and have a problem....
I have been given a table with 80,000 records and have been advised
that there are approx 5,000 duplicate records...
there are 7 fields that contain data and duplicate records will contain
same information for each record accross all fields.
(for record to be duplicated it must contain same data for each record
accross all 7 feilds)
I have run "find duplicate record query" and get list of duplicate
records and how many of each....( some 2 , some 3)
How can I extractor delete all duplicated records, leaving table with
clean set of records ????
Cheers
John Y
[Non-text portions of this message have been removed]
