Remove Duplicate Records....Pawan

[Guest]

Hello all...
I have an access table with around 2000 records. But few records are
duplicated. e.g. Say Record for student John is repeated twice in the table.
I want to delete duplicate records for which "Student" and "Class" fields are
same. How can I write query for this?

Thank You in advance.

-Pawan

 

[Nikos Yannacopoulos]

Pawan,

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