How do I delete one entire table from another table in access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a mis-match query between two different tables. I created make
table query from that query and now I need to delete the one entire table
from the other table. I keep getting an error that I need Specify the table
containing the records you want to delete. Please advise what I am doing
wrong.
 
On Fri, 20 Oct 2006 08:51:02 -0700, Jennifer Odell <Jennifer
I created a mis-match query between two different tables. I created make
table query from that query and now I need to delete the one entire table
from the other table. I keep getting an error that I need Specify the table
containing the records you want to delete. Please advise what I am doing
wrong.
Click to expand...

We don't know, because you did not tell us what you're doing.

Please post the SQL view of the delete query.

John W. Vinson[MVP]
 
Back
Top