Count Yes/No field in report?

  • Thread starter Thread starter RoadKill
  • Start date Start date
R

RoadKill

Hello,

How can I count the number of Yes and No's in a Yes/No field in a report?

For simplicity sake, my query will be Query1 and Yes/No field will be Field3
and Report simply Report1.

Also, I usually just use Excel or have the Report Wizard do my calculations
and then add/change them as needed, where is a good, simple source to get
started on calculations?

Thank you
 
Hello,

How can I count the number of Yes and No's in a Yes/No field in a report?

For simplicity sake, my query will be Query1 and Yes/No field will be Field3
and Report simply Report1.

Also, I usually just use Excel or have the Report Wizard do my calculations
and then add/change them as needed, where is a good, simple source to get
started on calculations?

Thank you
Click to expand...

Using unbound text controls in the report:

To count Yes:
=Abs(Sum([Field3]))

To count No:
=Sum([Field3]+1)
 
Thanks!

fredg said:
Hello,

How can I count the number of Yes and No's in a Yes/No field in a report?

For simplicity sake, my query will be Query1 and Yes/No field will be Field3
and Report simply Report1.

Also, I usually just use Excel or have the Report Wizard do my calculations
and then add/change them as needed, where is a good, simple source to get
started on calculations?

Thank you
Click to expand...

Using unbound text controls in the report:

To count Yes:
=Abs(Sum([Field3]))

To count No:
=Sum([Field3]+1)
Click to expand...
 
Back
Top