Help with DELETE QUERY

[taimysho0]

hello, im having trouble writing a delete query, when i run it i get a message saying "specify the table you want to delete" even though i did. here is my code below. i want to delete all rows from tblAllCellActivations where values are present in tblAllCellActivation.Assigned Voice # but in qryTrimLPC_Phone_3.Num is null





DELETE tblAllCellActivations.[Assigned Voice #], qryTrimLPC_Phone3.Num
FROM tblAllCellActivations LEFT JOIN qryTrimLPC_Phone3 ON tblAllCellActivations.[Assigned Voice #] = qryTrimLPC_Phone3.Num
WHERE (((qryTrimLPC_Phone3.Num) Is Null));

[taimysho0]

^ or in other words, delete everything in tblallcellactivation where the records dont match qrytrimLPC_Phone3

[JoeM]

Delete Queries often give me headaches when multiple tables are involved too.
Usually, what I do is to first create a Select query that selects the records I want to do delete. I then use that as the criteria of my delete query.
So this should work:

DELETE *
FROM tblAllCellActivations
WHERE tblAllCellActivations.[Assigned Voice #] IN
(SELECT tblAllCellActivations.[Assigned Voice #]
FROM tblAllCellActivations LEFT JOIN qryTrimLPC_Phone3 ON tblAllCellActivations.[Assigned Voice #] = qryTrimLPC_Phone3.Num
WHERE (((qryTrimLPC_Phone3.Num) Is Null)));