Counting Null Values in a Report

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.

Hi Dea,

Try:

=Sum(-IsNull([ClosedDateFieldName]))

Note the minus sign just after the first paranthesis. IsNull() returns
a -1 when the item is null, otherwise 0. So by summing up the negative of
each (-1)s you are in essence counting 1 for each null item. Alternatively
you could move the minus sign to the outside:

=-Sum(IsNull([ClosedDateFieldName]))

Clifford Bass

Dea wrote:
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.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/201001/1

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

--
Build a little, test a little.


"Dea" wrote:

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

Dea wrote:
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.