Delete/Update Query question? Is there a way to do this?

[bwalk037]

Hello,

I have a table that gets updated data monthly from an update query that I run at the beginning of every month. The table has the fields Account #, Acct Amt, Days over due, and date of last payment. This table keeps track of any accounts that have any over due balances that have not been paid.

The update query updates any new accounts that have been added to the list but, is there any way to create either a delete or update query that deletes any records that are no longer on the list? Basically, I need a way to delete the accounts that paid and therefore are no longer on the list.

Is there a way to do this?

Thank you

 

[John Big Booty]

Off the top of my head without seeing your DB. You could create a delete query that deletes any account with a zero balance, here I'm guessing that the account will update to zero once it has been paid.

 

[DCrake]

Why would you want to delete them? Surely you need the information for historic purposes.