Prev: Referential integrity. AutoNumbe r…
Next: Referential integrity. AutoNumber�
From: JimS on 19 Jan 2010 13:39
If you really feel you have to do this the way you describe, you probably
want to create a matrix of binary values (0 is true, 1 is false). Then you
can loop through the matrix and use boolean logic to develop the result.
--
Jim


"Jeff Boyce" wrote:

> You might want to revisit the math in your combinatorics.
>
> If you are taking 20 objects (tests) 2 at a time, you have 190 possible
> combinations.
>
> Then if you are taking them three at a time, you have approx. 63
> possibilities. Taken four at a time, ...
>
> So I'm guessing there are a very specific set of your "50 such"
> combinations.
>
> Why not use a table to hold the valid combinations, rather than try to write
> a fairly complex (and likely, "Too complex" from Access' viewpoint)
> expression?
>
> Regards
>
> Jeff Boyce
> Microsoft Access MVP
>
> --
> Disclaimer: This author may have received products and services mentioned
> in this post. Mention and/or description of a product or service herein
> does not constitute endorsement thereof.
>
> Any code or pseudocode included in this post is offered "as is", with no
> guarantee as to suitability.
>
> You can thank the FTC of the USA for making this disclaimer
> possible/necessary.
>
> "mls via AccessMonster.com" <u55943(a)uwe> wrote in message
> news:a25a78915af81(a)uwe...
> >I have 20 different tests and each time I have to check a minimum of 2
> > combinations upto a maximum of 12 different combination to create a
> > results.
> >
> > simple Ex:
> > If test1_result=yes and test2_result=no then result="A";
> > else if test1_result=yes and test2_result=yes then result="Mix A and B";
> > above example is just checking 2 conditions(tests). I am planning to check
> > atleast 12 conditions in one if statement and expecting to have 50 such if
> > statements.
> >
> > Jeff Boyce wrote:
> >>20 objects, taken how many at a time?
> >>
> >>"...create a result field ..." ?from what? ?consisting of what?
> >>
> >>More info, please...
> >>
> >>Regards
> >>
> >>Jeff Boyce
> >>Microsoft Access MVP
> >>
> >>> Hi,
> >>>
> >>[quoted text clipped - 5 lines]
> >>>
> >>> Thanks
> >
> > --
> > Message posted via AccessMonster.com
> > http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201001/1
> >
>
>
> .
>
 | 
Pages: 1
Prev: Referential integrity. AutoNumbe r…
Next: Referential integrity. AutoNumber�