Counting Null Values in a Report

  • Thread starter Thread starter Dea
  • Start date Start date
D

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.
 
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
 
Back
Top