Delete query question

G

Guest

Hi,
Is it possible to delete from more than one query in a delete query?
I have tried but i am getting an error asking to specify the table
containing the records i wish to delete?
Thanks
George
 
A

Allen Browne

A deletion should be on one table.

If you have set up a relationship with cascading deletes (Tools |
Relationships), the related records will be deleted as well.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Query: Could not delete from specified tables 0
Access 2010 append query to SQL is very slow 0
Delete query with joined tables 0
Specify the table containing the records you want to delete 9
Delete records containing certain info 14
Can't get delete query to work... 2
How does one report a bug in Access 2007 SQL? 4
Delete Queries 4

Top