Please read
http://support.microsoft.com/default.aspx?scid=kb;en-us;207761

***quote****

Delete Queries

When a delete query contains more than one table,
such as a query that deletes duplicate records from one of the tables,
the UniqueRecords property must be set to Yes for all versions of Microsoft
Access.

However, because the default value for UniqueRecords is No in Access 2000,
you must set the value of this property manually when you create a new
delete query in Access 2000.

To do so, follow these steps:
Open the delete query in Design view.
If the property sheet is not already open, on the View menu, click
Properties.
Click an empty area in the upper half of the query window so that the
property sheet displays "Query Properties" in the title bar.
Set the UniqueRecords property to Yes.
Save the query, close it, and then run the query.
***unquote***

good luck,

gary

Try the following:

DELETE DistinctRow dbo_tblOrderExtraCharges.OrderID
FROM [OrderID's To Delete] INNER JOIN dbo_tblOrderExtraCharges
ON [OrderID's To Delete].OrderID = dbo_tblOrderExtraCharges.OrderID

If that fails then try

DELETE DistinctRow dbo_tblOrderExtraCharges.OrderID
FROM dbo_tblOrderExtraCharges
WHERE dbo_tblOrderExtraCharges.OrderID in
 (SELECT OrderID's To Delete].OrderID
  FROM [OrderID's To Delete])

If that fails, then I suspect that you might want to post the table structure of
the tables you are using and the actual error message you are getting.