Count - Sum in a Report

[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?

 

[John Spencer]

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

 

[Jeff Boyce]

It all starts with the data. Without a better idea of your data, it may be
tough coming up with a "how to"...

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Evi]

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