Count Function In Group Footer

[rmp]

Hi,

It's been years since I've used access and the old format for counting no
longer works in Access 2003. I've read all the examples and nothing seems to
work. I need to count the number of times an item is true in a particular
field, the crosstab query doesn't work for me because I need to count in
about 15 fileds (all true/false). I've used the wizard, but keep getting the
same error: expression is not correct. Can anyone help me??

I create an unbound text box in the report, enter the count function and the
parameter to count if =true: =Count([helped], true), and I've tried
=Count([helped]=true)

HELP!

 

[John Spencer]

=Abs(Sum([Helped]))

Or

= Count(IIF([Helped]=True,1,Null))

IF you need to count 15 fields then you might be better off using a sub-report
in the header and base it on a query to get all the various counts.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County