How to i count a record with muptiple yes no fields

[New2bris31]

i have various records. each record has a number of yes/no fields [approx
15]. i want to generate a or query that shows me even if one of the field has
a no that record is counted as one. two no's in same record still one. each
month i will generate the report showing the number of records which have a
no in the field.

 

[Software-Matters]

You could set up a new calculated field in your query, something like this:

YesNo: iif([YesNo1] = No OR [YesNo2] = No OR [YesNo3] = No etc etc ,1,0)

Then if any of the YesNo fields have a No a 1 will be place in the new
calculated field. you can then filter all records with a 1 to use as you wish.

Regards
JD
--
<a
href="http://www.software-matters.co.uk/bespoke-database-design.html">Bespoke
Access Database Development</a>
<p>Software Matters</br>
Straightforward solutions that work</p>

 

[KARL DEWEY]

Another way --
YesNo: IIF(Abs([YesNo1] + [YesNo2] + [YesNo3] + [No etc]) < X ,1,0)
-- X being the number of Yes/No fields.

You could set up a new calculated field in your query, something like this:

YesNo: iif([YesNo1] = No OR [YesNo2] = No OR [YesNo3] = No etc etc ,1,0)

Then if any of the YesNo fields have a No a 1 will be place in the new
calculated field. you can then filter all records with a 1 to use as you wish.

Regards
JD
--
<a
href="http://www.software-matters.co.uk/bespoke-database-design.html">Bespoke
Access Database Development</a>
<p>Software Matters</br>
Straightforward solutions that work</p>

i have various records. each record has a number of yes/no fields [approx
15]. i want to generate a or query that shows me even if one of the field has
a no that record is counted as one. two no's in same record still one. each
month i will generate the report showing the number of records which have a
no in the field.