I am trying to delete duplicate records from a table. I have successfully created a query to find the duplicates. My problem is running the query in the following statement
SQLDeleteDuplicates = "DELETE " tblMoneyDue.*, tblMoneyDue.ID _
& "FROM tblMoneyDue WHERE (((tblMoneyDue.ID) = _
& "DLookUp("ID","qryListCopiesToDelete","ID" >1)))"
It is the DLookup part that is causing the problem! I am sure that I should not be using "" around ID and qryListCopiesToDelete but do not know where to go next.
Any help gratefully received