countif

  • Thread starter Thread starter Maz
  • Start date Start date
M

Maz

Is there a function for access that does the same as CountIf in Excel.
I would like to count records in a report by a specific criteria.
Is this possible??????

Thanks in anticipation

Maz T
 
Maz said:
Is there a function for access that does the same as CountIf in Excel.
I would like to count records in a report by a specific criteria.
Click to expand...


General forms of that kind of thing is:

=Count(IIf(condition, 1, Null))
or
=Sum(IIf(condition, 1, 0))
or
=Abs(Sum(condition))

The latter on relies on the Access definitions of True = -1
and False = 0
 
Back
Top