Counting Null Values in a Report

[Dea]

I have a report that is grouped by people, then by Reason Closed. I want to
count how many entries do not have a closed date. I tried the previous posts
but could not get it to work.

I have a group header for each person to group their categories together.

Thanks.

 

[KARL DEWEY]

Try this --
Sum(IIF([Reason Closed] Is Null, 1, 0)) AS Count_Null_Reason_Closed

 

[John Spencer]

Control with following expression as its source should work

=Count(*)-Count([ClosedDate])

Count(*) counts every record
Count([ClosedDate]) counts all instances of closed Date that are NOT null.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County