Tina,

Is the table Local (local means that is not a linked table
to another database)?

If not, try to put the bracket around the Linkbase.NUMBER.
Also make sure the table Linkbase has the field "NUMBER"
in there (Access is Case sensitive).

I hope this helps.

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

-----Original Message-----
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?




.

.