Remove a result from a query

[shm135]

I have an invoice table. This invoice table has a primary key
autonumber. I have about 10 different queries to return records that
meet certain criteria from the invoice table. When looking at some of
the results, there are some manual exceptions to each query's rules.
Is there anyway that I can click on one of the results in a query and
have that record added as an exception to that specific query so that
it doesn't appear anymore for that query?

Please let me know.

Thanks

 

[shm135]

I try to avoid answering a question with a question, so my answer is
"probably, yes."

But, I would ask, "Why do you want to do this?" If the manual exceptions
reflect a business rule, why not incorporate the rule in the query stack?

If you choose to implement one-off exceptions, over time you will have a
messy spaghetti that eventually becomes impossible to understand or
maintain, and perhaps more importantly, has no apparent connection to
the business rules.

To answer your question, some of the queries list problems found on
the invoice- such as being overcharged for a service. I manually
handle addressing these issues, and would like to remove a record if
it has been addressed. Not sure if this is possible yet...but let me
know if you have any suggestions. Thank you

 

[Phil Smith]

I would suggest an alternate path...
Add a field for an exception flag, and you can simply flag that record
in such a way that it will not show up in your queries. Also add an
Exceptions_Notes field, so when you have a record that is screwed
somehow, and you fix it, you can put something in the record itself
noting what your fix was. Could be free form, could be a list of a few
things, but you would always have that little bit of backup handy.

If you can't touch those tables, build another one to keep that info,
and link it up with your queries.

Phil