Record Count

[tony35]

I am attempting to create a feild on my report that will count specific entries within one column on a table. For instance, I have a column named "case status". The two options in the column are "open' and "closed". I would like to count all the "open" and "closed" individually in seperate fields on a report.

Open: 25
Closed: 105

Thank you for your help.

Tony

 

[dhookom]

Try:
=Abs(Sum([Case Status]="Open&quot)
=Abs(Sum([Case Status]="Closed&quot)

Duane
MS Access MVP