Count Null Values in a report

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.
 
G

Guest

In the Report Footer create a text box, in the ControlSource write

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

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count null fields 4
hours, minutes, seconds 4
Access Count dates within a Month 4
Null or No Null values in a parameter query 6
count of values 3
How do I reinstate a member? 2
count in report 2
Count the columns from one sheet and paste it in another sheet 0

Top