Correct Access SQL Statement for Multiple Criteria Deletion
Posted on 2009-02-14
I would like to delete rows from an Access table, I will be creating criteria with SQL DELETE and WHERE statements, for two separate criteria, in two fields. I have attempted using a DELETE query as well,
DELETE FROM table WHERE Field1="Instances" AND Field2 = "Findings";
Field1 criteria may be in rows 1 - 4, and Field2 criteria in rows 7 - 10. Assume that there are no rows in common that fulfill both criteria. In one SQL programming statement, I want to delete all of these 8 rows, and have not been able to thus far.