Delete Query based on the results of another query

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

Guest

I need to use a delete query to delete records from a table based on the
results of a find unmatched query. I have read in the unmatched query and
related it to the table. The select query will extract the records I need,
but the delete query will not delete the record. Is there a way to make this
happen.
 
I need to use a delete query to delete records from a table based on the
results of a find unmatched query. I have read in the unmatched query and
related it to the table. The select query will extract the records I need,
but the delete query will not delete the record. Is there a way to make this
happen.
Click to expand...

Please post the SQL of your unmatched query and the delete query.

John W. Vinson[MVP]
 
Back
Top