count records based on criteria

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

Guest

I am trying to count records in a group footer of a report.
I have a calculated field named " DaysEL ". I want to count the number of record
that are = 0 and >0 in this field. Can this be done? I can't seem to get it right

TI
 
dd said:
I am trying to count records in a group footer of a report.
I have a calculated field named " DaysEL ". I want to count the number of records
that are = 0 and >0 in this field. Can this be done? I can't seem to get it right.
Click to expand...


Lots of way to do that. Here's some example expressions to
get you going:

=Count(IIf(DaysEL > 0, 1, Null))

=Sum(IIf(DaysEL > 0, 1, 0))

=Abs(Sum(DaysEL > 0))
 
Back
Top