I have a query set up to find all duplicate records. Is there a way to run a query that will delete all duplicate records from a table?
I have a query set up to find all duplicate records. Is there a way to run a query that will delete all duplicate records from a table?
Yes if you do a query and select the asterik and put in the field for ther query. The asterik means all fields in the table.
Then select type of query, select delete query and when you run this, it will delete all records. Always make a copy of your database before making changes just in case you want something you deleted. This is a good practice to do. Once you delete the records you can't get them back.