What am I doing wrong?

[Ed]

I want to delete records in table C that are not in table Q.

DELETE Q.CableNo, C.*
FROM qryCableCreate AS Q RIGHT JOIN tblCables AS C ON Q.CableNo = C.CableNo
WHERE (((Q.CableNo) Is Null));

 

[Brendan Reynolds]

DELETE * FROM tblCables WHERE CableNo NOT IN (SELECT CableNo FROM
qryCableCreate)

 

[John Vinson]

I want to delete records in table C that are not in table Q.

DELETE Q.CableNo, C.*
FROM qryCableCreate AS Q RIGHT JOIN tblCables AS C ON Q.CableNo = C.CableNo
WHERE (((Q.CableNo) Is Null));

Including Q in the delete clause. In the query grid, uncheck its Show
box and make sure it says WHERE rather than FROM; equivalently

DELETE C.*
FROM qryCableCreate AS Q RIGHT JOIN tblCables AS C ON Q.CableNo =
C.CableNo
WHERE (((Q.CableNo) Is Null));


John W. Vinson[MVP]

 

[Ed]

Thanks