Count "Yes" and "No" responses in detail footer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my detail section of a report with seven columns, I have a column with
field name Reward with "Yes" or "No" responses as part of the record. In the
Detail footer, how can I add a text box to count the "Yes" and another to
count the "No" responses? Like =count([reward]="yes") or
=count([reward]="no")
Thanks for any assistance.
 
Yes/No fields store -1 for Yes and 0 for No.

Yes count:
=Sum(Abs([Reward]))
No Count:
=Sum([Reward]+1)
 
Hi Dan.
You could an unbound textbox in the footer band with
=Sum(Abs([Reward]))
for the yes count and
=Sum(Abs([Reward]="No"))
for the no count.
Hope this helps.
Fons
 
Back
Top