Counting Records in a report with specific values.

R

RobA

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
 
J

John Spencer

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"))
 
Top