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" 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�