Count null fields

[Steve Goodrich]

I have a form that I would like to add a text box to that will count how
many null entries there are in a given field

I don't know how to enter the text.

=count(*) will count all the records but how would I count all the null
entries in a field called 'Approved'

Thanks in advance for any help

Steve Goodrich

 

[Douglas J. Steele]

=Sum(IIf(IsNull([Approved]), 1, 0)

 

[Clifford Bass]

Hi Steve,

Or, to make it slightly shorter, you can take advantage of the fact
that true is represented by a -1 and use:

=-Sum(IsNull([Approved]))

or

=Sum(-IsNull([Approved]))

Clifford Bass

 

[Steve Goodrich]

Thanks Guys, Works perfectly.

 

[Clifford Bass]

You are welcome Steve.

Clifford Bass