I have to tables. One contains this weeks new customers, the other contains all customers. At the end of every week i need to check that none of the entrys in tblthisweek are duplicated int eh master table. hense i need to compare the tables and remove any duplicates in one table. I generated the query in access and im sure it should work but if i run it in access it tells me i have not selected a table ti delete records from.<BR>If i run it from VB im told &#039record already Deleted&#039.<BR>Please help<BR><BR><BR><BR>DELETE tbltemp.*, tbltemp.Criteria FROM tbltemp INNER JOIN tblmaster ON tbltemp.Criteria = tblmaster.Criteria WHERE (((tbltemp.Criteria)=[tblmaster].[criteria]));