Getting the following error message
"at most one record can be returned by this subquery"

unsure why subquery can only retrun one value.

Any help greatly appreciated. Attached is the query sql.

DELETE tblAF110Paid.AF110PaidID
FROM tblAF110Paid
WHERE (((tblAF110Paid.AF110PaidID)=(select * from qryremoveaf110final)));


thanks.

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