Ken,

Thanks for your help! I tried your suggestion and
I am still getting the same error msg. Do I have some
kind of block on the "linkbase" table that I am unaware of
????
Tina

-----Original Message-----
You need to put the "joined" table into a subquery so
that only one table is
in the main SQL statement:

DELETE Linkbase.*
FROM Linkbase
WHERE Linkbase.NUMBER IN
(SELECT [Linked Deletions18-1].[Number]
FROM [Linked Deletions18-1]);

--

Ken Snell
MS ACCESS MVP


"Tina" wrote in
message
...
Can anyone help me. Im' trying to deleting records in a
table called "linkbase" where the "NUMBERS" field
matches
the "Numbers" field in another table called Linked
Deletions 18-1.

My Sql Statement looks like this

DELETE Linkbase.*, Linkbase.NUMBER
FROM Linkbase, [Linked Deletions18-1]
WHERE (((Linkbase.NUMBER)=[Linked Deletions18-1].
[Number]));

I finally got the records I need to delete in Datasheet
view, however when I hit the Delete! button I get a
message "Could not delete from specified table". Any
ideas?




.