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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top