get rid of duplicate records

D

dlb1228

i have a huge table and have several records that are duplicates, is there a
way to get rid of one of the records where the loan # is a duplicate? for
example

name loan amt loan#
joe smith $25,000 123-45-6789
joe smith $25,000 123-45-6789
 
N

Nikos Yannacopoulos

The easiest way to do it is to create a query on the table and invoke
Totals (leaving the default Group By total function on all fields), so
you get unique records only; make it a make-table query, and put the
records in a temporary table; delete all records in the original table;
finaly, either (a) copy all records from the temp table to the original
one and kill the temp, or (b) kill the original table (in which case you
needn't have cleaned it up before) and rename the temp to the original name.

In any case *back up* before you try anything!

HTH,
Nikos
 
Top