Need help counting the Null Value

[Guest]

Greetings

I need to be able to add a calculation field that returns a value for the number of Null Values in a given report.

For example I use the following =Sum(Abs([fldStatus]="SAT")) control source to tell me how many of the records returned a value of SAT; however, this does not seem to work for counting the "Null" value

Any suggestions...end result is that I need to count then number of records that return a Null value in the fldstatus field

Thanks in advance for your help

Steve

 

[Allen Browne]

Try:
=Sum(Abs([fldStatus] Is Null))
or
=Sum(Abs(IsNull([fldStatus])))

You cannot use "equals" with Null. Explanation in:
Common errors with Null
at:
http://allenbrowne.com/casu-12.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I need to be able to add a calculation field that returns a value for the

number of Null Values in a given report.

For example I use the following =Sum(Abs([fldStatus]="SAT")) control

source to tell me how many of the records returned a value of SAT; however,
this does not seem to work for counting the "Null" value.

Any suggestions...end result is that I need to count then number of

records that return a Null value in the fldstatus field.

 

[Guest]

Thank you.