access training london - Deleting duplicate records from a table

There is a simple way of doing this, by using a Query and grouping.

Create a new query, showing the fields you want to deduplicate.
Run the query to ensure you have the correct records.
Go back to Design View, and click the AUTOSUM button on the toolbar. The one that looks like a reversed E.
This will add an additional line to the bottom of the design view, wth GROUP BY in the field. This basically Groups the records by unique entries.


Another way is to use SQL if you are familiar with it.
Once you have created the basic query, switch tothe SQL view and add the word DISTINCT after the first word SELECT.
This has the same effect.