Count null fields

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

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Steve Goodrich" wrote in message
. ..
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

"Douglas J. Steele" wrote:

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

Thanks Guys, Works perfectly.

"Steve Goodrich" wrote in message
. ..
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

You are welcome Steve.

Clifford Bass

"Steve Goodrich" wrote:

Thanks Guys, Works perfectly.