3086 Error on Delete Query

[86knight]

I'm wondering if someone can help on this error. It must be simple. I have included the delete distinctrow code and it still does not work. Please help.
Thank you.
DELETE DISTINCTROW [Freight Manager Data].*, [Freight Manager Data].Time
FROM ([04b Updated Records - Last Entry]
RIGHT JOIN [04a Updated Records - All] ON ([04b Updated Records - Last Entry].[Order #] = [04a Updated Records - All].[Order #]) AND ([04b Updated Records - Last Entry].MaxOfTime = [04a Updated Records - All].Time))
INNER JOIN [Freight Manager Data] ON [04a Updated Records - All].[Order #] = [Freight Manager Data].[Order #]
WHERE ((([Freight Manager Data].Time)<>[04b Updated Records - Last Entry]![MaxOfTime]));

 

[SydneyGeek]

It looks like the query runs across 3 tables, and it also contains DISTINCTROW and summary calculations like Max.
I'm prepared to bet that the query is not editable; if not, you can't directly delete records using the query. Are you trying to delete records in all 3 tables or only one?

Denis

 

[86knight]

Just trying to delete in "Freight Manager Data".
It works as a select but not a delete query.
Thank you.