Using a Delete Query to Flag for Generic Account Numbers

[50DollarNassau]

I have a question regarding running a delete query in MS Access and the capabilities that come with it. If I have a database built with various names and their respective account numbers, and of those names, roughly 5-10 have the same generic account number ("0000" or "9999"), how would I go about flagging for these generic account numbers? Ideally I would like to be able to check for generic account numbers on a weekly or monthly basis to make sure the data stays consistent and clean.

[JoeM]

I am not quite clear on your question.
Are you want to delete the records or flag them?

You would use a "DELETE QUERY" to physically delete/remove the record from the database.
You would use an "UPDATE QUERY" to update a field on a record (like a "flag" field).
You would use a "SELECT QUERY" to simply return records that meet specific criteria.

[50DollarNassau]

I would want to flag the accounts with generic account numbers and update them with a new, unique account number.

[JoeM]

OK, you would use an UPDATE QUERY to do that, and in the Criteria field under the Account Number, enter:

"0000" or "9999"

and you would enter the new Account Number you want on the "Update To" line of the Account Number field.

If you do not know how to create Update Queries, check out this tutorial: https://www.youtube.com/watch?v=Sh3r8VaBdf4
There are many other tutorials and articles you can find by Googling "Create Update Query in Microsoft Access".

[50DollarNassau]

Thanks, much appreciated!

[JoeM]

You are welcome.