indicate query values in form + relation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

dear all,

I have a table with several Yes/No fields. Now I would like to make my
query as flexible as possible and would like to use a form to indicate the
value of the yes/no fields but also the and /or relation for the query since
different combinations are possible .

For example my table looks like:
Card 2004 (yes/no)
Report (yes/no)
Brochure (yes/no)

I would like to have form where I can indicate
Card 2004 (yes /no)
AND - OR
Report (yes/no)
AND - OR
Brochure (yes/no)

Is this possible with one single query and one single form ? Do I have to
program this ?

Thanks in advance,
 
If you have 3 yes/no fields, you can fill them in with any combination of
yeses and nos.
 
indeed, but I have at least 15 different fields so I would like to have a
more general rule than trying to write down all the different combinations...
 
I guess I'm still not sure what you wish to accomplish by writing down all
the different combinations...
 
With the example of only 3 fields you can make the combination
field1 = true/false AND field2= true/false AND field3= true/false

The join is always AND !

It is also possible to make a query like this
field1 = true/false OR field2= true/false OR field3= true/false
The join is alway OR

But what I want now is also that I can select on a form the different
interrelations of the query (AND / OR)

so all the combinations are possible:
field1 = true/false (I can choose on form AND/OR) field2= true/false (I can
choose on form AND/OR) field3= true/false
 
Back
Top