For each lot or record , you will have
Item1 Item2 Item3 Item 4 Item5 Item6
The challenge is that the items that are defective are not known in advance.
From: "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
Sent: Saturday, 12 March 2016, 14:01
Subject: Re: [MS_AccessPros] INSPECTION
Probably, but we would need to know the layout of your relevant tables.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
On Mar 12, 2016, at 2:15 PM, Adeboyejo Oyenuga email@example.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
i am looking for help with a code for combinations for an inspection problem which can be generalized to similar problems.
Suppose there are 14 items to checked for defects in lots of 6 each. The idea is to be able to catch a lot with 5 defectives if that lot contains 5 defectives. I know combination wise, this should give 579 combinations.
Is there any way this can be handled in MSAccess ?
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 (3)|
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.