Hi All
In my example db I have created a query that looks for dups in a table and copies the results to a new table. Is what I am trying to do is delete all the dups except 1 from the main table. It was suggested to do it this way then create a delete query to delete all the entries in the main table based on the results from the second table and then create an append query to move the single results from the query table back to the main table, thus just having 1 entry of each.
I am struggling with how to create the delete query. I am no good at sql so any sql ideas will have to explain where I put the code etc.
Many thanks in advance.
Ian
In my example db I have created a query that looks for dups in a table and copies the results to a new table. Is what I am trying to do is delete all the dups except 1 from the main table. It was suggested to do it this way then create a delete query to delete all the entries in the main table based on the results from the second table and then create an append query to move the single results from the query table back to the main table, thus just having 1 entry of each.
I am struggling with how to create the delete query. I am no good at sql so any sql ideas will have to explain where I put the code etc.
Many thanks in advance.
Ian