Hi there, I have a table with over 30,000 records, but many are duplicates. I did a "find duplicates" query and then created a query that grouped the duplicates so that I had a list of the ones I wanted to delete. I then created a delete query where I joined the duplicate results up with original table. I put the asterick in the FROM column and then in the Where column I put tblContact![ContactID]=qryDuplicates![ContactID]
I have tried to change the syntax and the format of the query, to no avail. I keep getting different messages, the most common is "cannot delete from the specified table". This table is the child in all the relationships and I have no problem deleting from it otherwise. I think I have just set up this delete query wrong. Can anyone help? Is there a better way to delete duplicates?
Dawn
I have tried to change the syntax and the format of the query, to no avail. I keep getting different messages, the most common is "cannot delete from the specified table". This table is the child in all the relationships and I have no problem deleting from it otherwise. I think I have just set up this delete query wrong. Can anyone help? Is there a better way to delete duplicates?
Dawn