Simply put, I am trying to see how to use Access to make combinations of possibilities .
In the instant case, if a batch consists of 6 items at once, to ensure you are able to catch a batch that has 6 defectives, you need to have 3,003 inspections. This is easier as this consists of all the possibilities
What I am interested in is ensuring that a batch that has 5 defectives must not escape if 5 are present among the 14 . In this case you will need to have 371 inspections. How to have these theoretical possibilities laid out as combinations in Access is what I am aiming at.
From: "email@example.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
Sent: Sunday, 13 March 2016, 11:58
Subject: [MS_AccessPros] Re: INSPECTION
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: Adeboyejo Oyenuga <firstname.lastname@example.org>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (13)|
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.