This should be a simple delete query, I have 2 tables 1 has 1 record and 1 field field PartNum retrieved from a form field, table 2 has 6000 records with 55 fields one of which is PartNum. I need to locate the record from the field in table 1 and delete if found the record in table 2. I get the error message Specifiy the table containing the records you want to delete. I'm very new to Access and SQL