Count Yes/No field in report?

[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

 

[fredg]

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

Using unbound text controls in the report:

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

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

 

[RoadKill]

Thanks!

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

Using unbound text controls in the report:

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

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