Count - Sum in a Report

  • Thread starter Thread starter Gitche Gumee
  • Start date Start date
G

Gitche Gumee

I have a report that displays information about IT Projects. The report
includes 46 fields for each project and shows where required information is
missing. What I want to do is to display a count of the number of "missing
info" fields for each project.

I have worked out a rather clumsy solution that gives me this number, which
uses 46 counters that are then tallied. Is there a neater, less awkward way
to do this?
 
You might try an expression like the following.

(46 * Count(*)) - Count([FieldName1) - Count(fieldname2) - Count(fieldName3) -
Count(fieldName4)...-Count(fieldName46)


If there are some fields that will never have missing information then you can
shorten the expression.
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 
If you want to count how many missing fields there are in a *row* of data
then you can use this in a query

=Abs(IsNull(Field1)) + Abs(IsNull(Field2)) +Abs(IsNull(Field3))



Evi
 
Back
Top