Query deleted records in specified table, now doesn't - why?

[Guest]

I'm trying to delete records in Table 1 (Appointments) which are linked to
Table 2 (Leads). So I created a query that says:

DELETE Appointments.*, Appointments.ApptStatus, Leads.Updated, Leads.Source
FROM Appointments INNER JOIN Leads ON Appointments.LeadID = Leads.LeadID
WHERE (((Appointments.ApptStatus)="A" Or (Appointments.ApptStatus)="B" Or
(Appointments.ApptStatus)="C" Or (Appointments.ApptStatus)="D" Or
(Appointments.ApptStatus)="E") AND ((Leads.Updated)>Date()-2) AND
((Leads.Source)="X"));

However, I keep getting an error: Couldn't Delete From Specified Table.

I want this query to remove the records in Table 1 based on the selection
criteria.

 

[John Spencer]

You are attempting to delete from both tables. Remove the references to
Leads fields in the DELETE clause.

I would try the following

DELETE DISTINCTROW Appointments.*
FROM Appointments INNER JOIN Leads ON Appointments.LeadID = Leads.LeadID
WHERE (((Appointments.ApptStatus)="A" Or (Appointments.ApptStatus)="B" Or
(Appointments.ApptStatus)="C" Or (Appointments.ApptStatus)="D" Or
(Appointments.ApptStatus)="E") AND ((Leads.Updated)>Date()-2) AND
((Leads.Source)="X"));

If that fails then post back.

 

[Marshall Barton]

I'm trying to delete records in Table 1 (Appointments) which are linked to
Table 2 (Leads). So I created a query that says:

DELETE Appointments.*, Appointments.ApptStatus, Leads.Updated, Leads.Source
FROM Appointments INNER JOIN Leads ON Appointments.LeadID = Leads.LeadID
WHERE (((Appointments.ApptStatus)="A" Or (Appointments.ApptStatus)="B" Or
(Appointments.ApptStatus)="C" Or (Appointments.ApptStatus)="D" Or
(Appointments.ApptStatus)="E") AND ((Leads.Updated)>Date()-2) AND
((Leads.Source)="X"));

However, I keep getting an error: Couldn't Delete From Specified Table.

Don't list fields in the Delete clause:

DELETE Appointments.*
FROM Appointments INNER JOIN Leads
ON Appointments.LeadID = Leads.LeadID
WHERE Appointments.ApptStatus IN("A","B","C","D","E")
AND (Leads.Updated>Date()-2) AND (Leads.Source="X")

BUT, if you were hoping to delete records from both tables,
I don't think that's possible.

 

[Guest]

Thank you very much for your help. It resolved the problem.