countif

[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

 

[Marshall Barton]

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.

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