Delete query not working

[Gkirkup]

I have a simple delete query which is supposed to delete records in one table if a match is found in another table. Here is the query:

DELETE ENTR_HECIS.HECI, ENTR_HECIS.PARTNUMBER
FROM ENTR_HECIS LEFT JOIN BELLCO ON ENTR_HECIS.HECI = BELLCO.HECI
WHERE (((ENTR_HECIS.PARTNUMBER)=[PARTNUM]));

When I run this, I get the error message 'Specify the table containing the records you want to delete'. I can't see the problem. Don't I specify the ENTR_HECIS table?

Robert

 

[PNGBill]

You should only need one field selected in the query to delete the record.

Change the query to Select and confirm the records you wish to delete are displayed.

Change it back to Delete and it should work.