convert query to query

[Guest]

My delete query is asking "which table to delete records from?"

I used the asterick of the table from which I want the records deleted.

Can't figure it out.

 

[John Vinson]

My delete query is asking "which table to delete records from?"

I used the asterick of the table from which I want the records deleted.

Can't figure it out.

Well, we can't either... *you* can see the query; we cannot.

Care to open the query in SQL view and post it here?

Just a GUESS: the table from which you wish to delete records should
be the only table mentioned in the DELETE clause, as in

DELETE TableA.*
FROM TableA Inner Join TableB
ON TableA.ID = TableB.ID
WHERE TableB.Action = "Delete Me";

rather than

DELETE TableA.*,TableB.Action
FROM...

John W. Vinson[MVP]