Count Null Values within a field in a report

J

Julianne

Access 2003 Report question: HELP! I have a report in which I need to count
the number of blanks/null values. E.g., Field is dateinjured, some of the
people have entered the dateinjured, some have not. I need to count the
number of records in which dateinjured is not completed / is a null value.
 
M

Marshall Barton

Julianne said:
Access 2003 Report question: HELP! I have a report in which I need to count
the number of blanks/null values. E.g., Field is dateinjured, some of the
people have entered the dateinjured, some have not. I need to count the
number of records in which dateinjured is not completed / is a null value.
Click to expand...


Use a text box in a group footer and/or the report footer
section with this kind of expression:

=Abs(Sum(Nz(dateinjured. "") = ""))
 
Top