Counting Various Fields

  • Thread starter Thread starter Jason Rogers
  • Start date Start date
J

Jason Rogers

I know how to use count so that I count all the records in my report, but is
it possible to count records meeting certain conditions? In other words, I
have a report that has a Yes/No field on it, and I'd like to be able to
count all the records that have Yes in them and display the total. Same
thing with a check box I have, I'd like to count all the records where the
box is checked. Any help is greatly appreciated. Thank you.
 
A yes/no field stores either 0 or -1. To count the yes values, use:
=Abs( Sum([YourField]) )
 
Back
Top