Need to have 19 yes/no choices to query from, using OR function.

[Guest]

I have a form that is a yes/no check box. There are 9 departments, within
each department there are at least 19 checkboxes. (ie: CE is department
with VBS, Snacks, Arts & Crafts). It is a survey to see who can work with
differnt things. I need a list of all the ones who check YES in any of the
19. I was going to make 9 query's (1 for each dept). But I have been unable
to get all 19 rows with the =True critiera. How would I accompolish this?

 

[Joseph Meehan]

I have a form that is a yes/no check box. There are 9 departments, within
each department there are at least 19 checkboxes. (ie: CE is department
with VBS, Snacks, Arts & Crafts). It is a survey to see who can work with
differnt things. I need a list of all the ones who check YES in any of
the
19. I was going to make 9 query's (1 for each dept). But I have been
unable to get all 19 rows with the =True critiera. How would I
accompolish
this?

In a query use a nested IIF statement nesting all 19 fields.

Come to think of it you should be able just use a formula adding all 19
fields the result will be 0 for none or -1 to -19 for any with a yes.

You used the term rows. I hope you mean fields You may have a table
design issue. What do your tables look like?