Delete Query Question

[GH]

I'm trying to run a DELETE query and am getting the
following error:
"Specify the table containing the records that you want to
delete".
I have a INNER JOIN with Table1.ID and Table2.ID with
Table1.ID as the only field in the DELETE query. I
suspect that the JOIN is causing the issue and may need to
use a SQL SELECT Statement as the criteria for Table1.ID
field rather than a JOIN (if this will work).
Can anyone help with the coding on this? Thanks.
Gary

 

[Steve Schapel]

Gary,

I couldn't help but notice that there seem to be three recent posts to
this newsgroup from you on this same question. Any reason for this?
It is especially confusing givan that all 3 posts have different
entries in the "From:" field.

Anyway, the answer to your question is that for a Delete Query, you
need to drag the * from the table you want to Delete from intoi the
query design grid. The Join between Table1 and Table2 should be ok.

- Steve Schapel, Microsoft Access MVP