Count null fields

  • Thread starter Thread starter Steve Goodrich
  • Start date Start date
S

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