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. "") = ""))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Nulls & Not Nulls in Reports 2
Grouping and Counting null records 2
counting records 0
A03 - count in report footer gives me #Error? 0
Sum a field with null value 5
if it is null how not to get the #error 1
Counting Null Values in Report 1
Reporting null values or blank sheets 3

Back
Top