Tina,

I have try a sample of my own data using the query that I
suggested. Of course, both table are local to this access
program. There is no problem with the query. My next
guess is that the table Linkbase is not local to your
access program. It is an link table or things.
The usually to delete from a link table you have to have
an primary key defined in that link table.
If that table is not linked or has a primary key, then I
am out of ideas.

I hope this help.

-----Original Message-----
I'm sorry to be a pain in the hmhm. I tried your
suggestions. It is still not working. I double checked
both tables, names, field names etc.. for case
sensitivity. I am able to see the records that art to
be
deleted in datasheet view, so I know they are being
located with the query. But, for whatever reason, once I
hit "Delete" I keep getting the "Could not delete blah
blah blah". As far as I know, Linkbase is not linked to
any other tables. It does have a different Icon in front
of the name, it has a little flipped open notebook where
the other tables all have the little data sheet. I don't
have a clue why! Anyway anything else you can think of
would be greatlty appreciated!

Tina


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




.

.

.

.