Delete Query

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

Guest

I have two queries which I have joined through a field. I am trying to delete
records from one query based on a criteria. I had accomplished this using
joined tables but due to permission issues, I am having to change tables to
queries. I dont know if one can delete records from a query. Can someone help?
 
Neeraj,

Yes, you can delete records via a query... as long as it is an
updateable query. If the nature of the delete query's component
queries, or the nature of the join between them, will mean the query is
non-updateable, you will need to take another approach. Please post
back with more datails if you need more explicit help.
 

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
Have both records from two queries/tables under one Query without related fields. 0
Delete query with joined tables 0
Specify the table containing the records you want to delete 9
Delete query using criteria from another query 1
cannot delete from "specified tables" 3
How does one report a bug in Access 2007 SQL? 4
Delete sub query problems 4

Back
Top