Hi All
I am trying to delete dups from a table whilst leaving one entry. I have created a query to find the dups and then copy them to a temp table. This shows me one of each dup in the table. I am now trying to create a delete query using wizard (not sql) to delete the dups in the main table using the data in the temp table. I want to base the delete on all fields in the temp table to ensure I only delete the dups that share the same data, some asset numbers are listed with earlier dates, I want to keep these.
What do I drag into the delete query and what criteria do I add?
I will then run an append query to put the single entry in the temp table back in to the main table, if that makes sense.
Thanks in advance
I am trying to delete dups from a table whilst leaving one entry. I have created a query to find the dups and then copy them to a temp table. This shows me one of each dup in the table. I am now trying to create a delete query using wizard (not sql) to delete the dups in the main table using the data in the temp table. I want to base the delete on all fields in the temp table to ensure I only delete the dups that share the same data, some asset numbers are listed with earlier dates, I want to keep these.
What do I drag into the delete query and what criteria do I add?
I will then run an append query to put the single entry in the temp table back in to the main table, if that makes sense.
Thanks in advance