GC Many thanks ...worked well ...now havee "clean" table
John Y At 04:26 PM 27/06/2008, you wrote: >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 : ><mailto:ms_access%40yahoogroups.com>[email protected] >[mailto:[EMAIL PROTECTED] De la part de John Young >Envoyé : jeudi 26 juin 2008 11:48 >À : <mailto:ms_access%40yahoogroups.com>[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] > > [Non-text portions of this message have been removed]
