Exception

[pltnsgt]

I have a data base of over 40,000 accounts. When I run my quires I am able to find accounts that may have errors and have them reviewed. Is there a way to exclude those accounts when the query is run again? Something like a table of exceptions to the query? I am unable to remove the data from the data base and with more then 40,000 accounts it would take a very long time to manually do it. Thanks.

 

[RuralGuy]

You could put the key data in an UnderReview table and then include a Not IN condition in your query. If you have a field available in the main table then tag the record as UnderReview and exclude it. With either choice you will need a means of removing the record from the UnderReview status.