Counting Yes/No Fields

[acepayne]

Hello,

Well, I am encountering a similar problem with a few reports that I am building.

Each record in the underlying query/table has a number of Yes/No Fields. I would like to provide a count of the "Yes's" for each of these fields in my report.

So, it would look something like this:

Field1 Field2 Field3
Y N N
Y Y N
Y Y Y
--------------------------
3 2 1

What method would you suggest for getting these totals?

Thanks!

 

[Fornatian]

Use an unbound control in the report sections footer and use this formula as the control source:

=Sum(Iif([TheFieldName]=True,1,0))

Ian

 

[acepayne]

I knew there should be something easy like this!!

This is excellent.

Thanks a bunch, Ian!