Access 2003. Count check boxes in multiple fields.

[J Hall]

Access 2003.

I have a query which pulls in a list if ID numbers with about 6 check box fields. In my report, I need to know how to count the number of ID numbers that have 2 or more of the fields checked.

Example:
There are (3) ID numbers listed that have Field A and Field B checked. How do I get the (3) to show in my report?

Thanks for you help.
J

[liimra]

Solution/

Please refer to the following post which answers your question.

http://bytes.com/topic/access/answer...-2-chkbxs-true.

*Note the attached database there.

Regards,
Ali

[J Hall]

Thanks Ali, I just had to remove the = before the first IIf and it worked

=sum(IIf([A]=0 And [b]=0,0,IIf([A]=0 And [b]=-1,0,IIf([A]=-1 And [b]=0,0,"1"))))

Now here is another one I've been struggling with for a couple of weeks.

On another report I have a query that has records with both Check box fields and Test Fields.

I was able to get a sum of all the records in that query that had the text "GAMC" in the two fields [Pl Ri Ki] & [Pl Lt Ki] by using

=Sum(IIf([Pl Rt Ki]="GAMC",1,0))+S um(IIf([Pl Lt Ki]="GAMC",1,0) )

Now I want to know how may of that text from the two fields are on the records of two check fields.

From Column A (check box yes) and Column B (check box yes), how many times was "GAMC" in {Pl Rt Ki} & {Pl Lt Ki}

Hope that makes sense and is it doable?
I think I will also start a new thread on this one.

Thanks again,
J

[liimra]

Solution/

Moved here:

http://bytes.com/topic/access/answers/894406-access-2003-count-text-records-checked-boxes#post3598346

Regards,
Ali