Delete Qry From Select query?

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

Guest

I have a query that finds the same records that exist in 2 different
tables-duplicates (purpose is to remove them from the place that they dont
belong).
When I find them i want to delete the one i dont want from the table it
doesn't belong in. I tried to modify the find "match" query into a delete
query-doesn't work.

How can i delete the records it finds automatically once i know which table
i want to delete from? Or how can i make it so that you can choose which
table to delete from and then delete it?
 
Create a second query, that uses the results from the first, to specify the
records to delete.
 
Back
Top