Delete Records in Table A that Match Records in Table B?

[foxhound]

I have two tables: Hours History and Hours Adjustments. Both have the same fields: EmpNo, EmpName, DBA, NumHrs, and Date. Is there a way to have a record deleted from Hours History if it matches identically to a record in Hours Adjustment? I do not want to delete the record in Hours Adjustment, only in Hours History.

Thanks in advance for any assistance you can offer

Foxhound

 

[guybrush]

Join every field

Have you tried joining every field from both tables, and selecting * from the Hours History Table?


DELETE DISTINCTROW [Hours History].*
FROM [Hours History] INNER JOIN [Hours Adjustments] ON ([Hours History].Date = [Hours Adjustments].Date) AND ([Hours History].NumHours = [Hours Adjustments].NumHours) AND ([Hours History].DBA = [Hours Adjustments].DBA) AND ([Hours History].EmpName = [Hours Adjustments].EmpName) AND ([Hours History].EmpNo = [Hours Adjustments].EmpNo);

This will select all of the records that are identical from both tables, and delete them from the Hours History Table. (An importaint option is the DISTICTROW option, which is found by going to the query properties, and setting the "Unique Records" Property to YES.

Good luck.

 

[foxhound]

Thanks a million!

That worked beautifully! Thank you so much!

:D Foxhound