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
