How do I select records to be deleted in a database using a list?

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

Guest

I have a database where I need to delete records where the client numbers
match in another table. I have been able to create a relationship to
identify the records but cannot delete them because of the join. There are
750 matching records out of 9,000 and I need to save those records to another
table. I am new at this....please help me..I'm going nuts trying to figure
this out.
 
temporarily add a Yes/No field to the table that has the records you want to
delete. run your query, making sure you include the Yes/No field. once
you're satisfied that the correct records are being returned, change the
query to an Update query, setting the value of the Yes/No field to True.
then run the Update query. now those records are "marked", in the table. you
can run a Delete query on that table, by itself, pulling only those records
where the Yes/No field = True.

hth
 
Back
Top