Count Null Values in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a date field in a report called Services Terminated. I want to count
those dates vs. null values to determine how many "active" (Services not
terminated) accounts I have. Thanks.
 
In the Report Footer create a text box, in the ControlSource write

=Sum(IIf([DateFieldName] Is Null,1,0))
 
Worked perfect. Thanks a bunch!!!

Ofer Cohen said:
In the Report Footer create a text box, in the ControlSource write

=Sum(IIf([DateFieldName] Is Null,1,0))

--
Good Luck
BS"D


Nick CWT said:
I have a date field in a report called Services Terminated. I want to count
those dates vs. null values to determine how many "active" (Services not
terminated) accounts I have. Thanks.
Click to expand...
Click to expand...
 
Back
Top