I'm not sure I've understood your situation properly but one trick I use for such cases is that in Access a comparison returns 0 or -1 for false or true.
You use the term "lot" for a "row" of six items but also seem to use it for the whole "batch".
Let's take the simplest case of rejecting a "lot" when it has five "bad" items then, symbolically,
Reject = ((Item1 = Bad) + (Item2 = Bad) + ... (Item6 = Bad)) <= -5
Purists might want to take ABS() of the "booleans" in order to turn minus one into plus one and then to be able to compare to plus five. This also has the advantage of working when applied to other environments where "true" is just 1 rather than -1.
Posted by: firstname.lastname@example.org
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (11)|
Save time and get your email on the go with the Yahoo Mail App
Get the beautifully designed, lighting fast, and easy-to-use, Yahoo Mail app today. Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.