Minggu, 13 Maret 2016

Re: [MS_AccessPros] INSPECTION

 

Dave-


That was me.  14 items taken 6 at a time is:

   14!
—————
6!(14-6)!

Or

    14!
—————
  6! 8!

Or

14*13*12*11*10*9
———————————
    6*5*4*3*2

Work it out from there.


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 
(Paris, France)



On Mar 13, 2016, at 7:34 PM, 'Dave Williams' davewillgmale@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:


Ade,
 
That's 7 x 53, another prime number. How did you work that out? If we knew your method it would help to understand what you want. Also how did you get 3,003 in your other email?
 
Dave
 
----- Original Message -----
Sent: Sunday, March 13, 2016 4:45 PM
Subject: Re: [MS_AccessPros] INSPECTION

 

Hi Dave, i made a mistake. It should be 371 combinations.

Ade.





From: "'Dave Williams' davewillgmale@gmail.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Sunday, 13 March 2016, 10:35
Subject: Re: [MS_AccessPros] INSPECTION

 

Ade,
 
How do you work out 579? It's 3 x 193 (a prime number), so does not come from ratios of factorials normally involved in numbers of combinations.
 
Dave W
 
----- Original Message -----
Sent: Saturday, March 12, 2016 1:15 PM
Subject: [MS_AccessPros] INSPECTION

Hi all,

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 ?

Thanks.

Ade.








__._,_.___

Posted by: John Viescas <johnv@msn.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (15)

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.


.

__,_._,___

Tidak ada komentar:

Poskan Komentar