Count Null Values within a field in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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. "") = ""))
 
Back
Top