Remove duplicate recordsThis tool will find all records which contain duplicated data. Comparison is made according to columns selected from the list. If, for example, you have a table as follows: ------------------------------------------------ First nameLast nameE-mail address JoeSmithJoe@hoai.net JoeOvenJoe@adg.net JoeSmithJoe@hoai.net ------------------------------------------------ If you select Last name, the column e-mail address after table processing will thus be: JoeSmithJoe@hoai.net JoeOvenJoe@adg.net ------------------------------------------------ If you select First name, the column itself or in combination with any other column after table processing, the results will thus be: JoeSmithJoe@hoai.net The program detects 3 identical values and leaves a single record while deleting the duplicates within the First name column.
 Create backup copy of the current table Before it introduces a single change, the program will create a backup copy of your table. The new table name will be of the: : table name + '_Backup' type. Make new table with the results The data will not be erased if you select this option; a new table containing results processing will rather be created. Filter through text file Remove domains Repair database Compact database See Also: Working with tables Database Wizards E-mail merge | 
