Append to delete query?

[sdkramer]

An append query with criteria like this works:

INSERT INTO tblA (item)
SELECT tblb.*
FROM tblb, tblc
WHERE (((tblb.item)=[tblc]![item]));

but when I make it a delete query it changes to :

DELETE tblb.item
FROM tblb, tblc
WHERE (((tblb.item)=[tblc]![item]));

it says "specify the table containing the records you want to delete." I can't get rid of the tblc because I need it for the criteria. Is there any way I can get this query to work?

Thanks in advance,

Seth

 

[Jon K]

Make a backup copy of the table tblb. Then try this query:-

DELETE *
FROM tblb
WHERE item in (Select item from tblc);