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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CW1956 - 03 Jul 2006 00:53 GMT

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.

Signature

Reply to this Message

tina - 03 Jul 2006 01:08 GMT

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

> 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.

Reply to this Message