Counting Records in a report with specific values.

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

Guest

I would like to count the "YES" values in a report field called NEWSBYPOST,
can someone give me a pointer on how to do this please.

Many thanks
 
Assuming that you want to do this in the report footer or in some group
footer. Set a control's value to

=Abs(Sum([NewsByPost]=True))

If the field value is actually the string YES then
=Abs(Sum([NewsByPost]="Yes"))
 
Back
Top