I think the query should be :
DELETE tblAF110Paid.AF110PaidID
FROM tblAF110Paid
WHERE (((tblAF110Paid.AF110PaidID) in (select * from qryremoveaf110final)));
and moreover,
(select * from qryremoveaf110final) will not work if this table has more than one column.
Please specify the column instead of *
Om Prakash
|