Count occurences of Yes or No

  • Thread starter Thread starter Raymond Clarke
  • Start date Start date
R

Raymond Clarke

I have a report which lists quality assurance results.
For each record selected in a time range it will display
if the the record was checked, and it will display Yes or
No in a text box. I need to count the number of times Yes
appears for an individual. I am having alot of trouble
with this, so if someone can help, I would appreciate it.

Raymond
 
I have a report which lists quality assurance results.
For each record selected in a time range it will display
if the the record was checked, and it will display Yes or
No in a text box. I need to count the number of times Yes
appears for an individual. I am having alot of trouble
with this, so if someone can help, I would appreciate it.

Raymond
Click to expand...

Raymond,
To count Yes:
=Abs(Sum([CheckBoxName]))

To Count No:
=Sum([CheckBoxName]+1)
 
Fred,

The field is a textbox, would you do the same?

Raymond
-----Original Message-----
I have a report which lists quality assurance results.
For each record selected in a time range it will display
if the the record was checked, and it will display Yes or
No in a text box. I need to count the number of times Yes
appears for an individual. I am having alot of trouble
with this, so if someone can help, I would appreciate it.

Raymond
Click to expand...

Raymond,
To count Yes:
=Abs(Sum([CheckBoxName]))

To Count No:
=Sum([CheckBoxName]+1)
--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.
.
Click to expand...
 
Fred,

The field is a textbox, would you do the same?

Raymond
-----Original Message-----
I have a report which lists quality assurance results.
For each record selected in a time range it will display
if the the record was checked, and it will display Yes or
No in a text box. I need to count the number of times Yes
appears for an individual. I am having alot of trouble
with this, so if someone can help, I would appreciate it.

Raymond
Click to expand...

Raymond,
To count Yes:
=Abs(Sum([CheckBoxName]))

To Count No:
=Sum([CheckBoxName]+1)
--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.
.
Click to expand...
Click to expand...

You posted that
time range it will display if the the record was checked <
Click to expand...
So I assumed you have a check box field in the Report's record source.
If so, and it is included in the Detail section, then Yes, it should
count the Yes results.

If you are using a text control to show "Yes" in place of the check
box, I think it should still work as long as the actual CheckBox field
is included in the section (either not visible or visible).

If not, (or if the actual check box field is not included in the
section) try:
=Sum(IIf([YesTextControlName] = "Yes",1,0))
Or try:
=Sum(IIf([YourTextControlName]=-1,1,0))
 
Back
Top