shieldsco
asked on
Access Delete Query Based on Criteria in Another Table
I get the an error "Specify the table containing the records you want to delete" when I try to execute the query below. Any thoughts.
DELETE tbl_Expiriation.*, tbl_MOU.[On R11]
FROM tbl_Expiriation INNER JOIN tbl_MOU ON tbl_Expiriation.[System Short Name] = tbl_MOU.[System Short Name]
WHERE (((tbl_MOU.[On R11])="No"));
DELETE tbl_Expiriation.*, tbl_MOU.[On R11]
FROM tbl_Expiriation INNER JOIN tbl_MOU ON tbl_Expiriation.[System Short Name] = tbl_MOU.[System Short Name]
WHERE (((tbl_MOU.[On R11])="No"));
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER