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

Similar Threads

Count a specific value. 7
Count of Report values in Report Footer 3
Counting in a text field for a specific group 6
Summing and counting in Reports 4
How do i count records I've selected in a report? 1
Count Only Yes Records on Report 4
counting values 6
STATE EMPLOYEE REQUESTS HELP WITH REPORT!!! 1

Back
Top