The Following is my Sql, iam able find the record to delete but iam unable to delete as its Says "Specify the table Containing the records you want to delete"
DELETE tblBciCMiA.ContNo, tblBciCMiA.InvNo, tblBciCMiA.Seller, tblBciCMiA.Buyer, tblBciCMiA.Qty, tblBciCMiA.Cert, tblBciCMiA.RQty, tblBciCMiA.RDate, qryBciCMiA.qInvNo
FROM tblBciCMiA LEFT JOIN qryBciCMiA ON tblBciCMiA.[InvNo] = qryBciCMiA.[qInvNo]
WHERE (((qryBciCMiA.qInvNo) Is Null));
DELETE tblBciCMiA.ContNo, tblBciCMiA.InvNo, tblBciCMiA.Seller, tblBciCMiA.Buyer, tblBciCMiA.Qty, tblBciCMiA.Cert, tblBciCMiA.RQty, tblBciCMiA.RDate, qryBciCMiA.qInvNo
FROM tblBciCMiA LEFT JOIN qryBciCMiA ON tblBciCMiA.[InvNo] = qryBciCMiA.[qInvNo]
WHERE (((qryBciCMiA.qInvNo) Is Null));