Owen has attended:
Access Intermediate course
Deleting duplicate records from a table
I have a table with lost of ducpolicate records (after importing data from an Excel spreadsheet) is there a simple way of deleting those duplicate records? If so How? there are far to may records to delete them manually.
I look forward to you reply
Thanks
Owen
RE: 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.
