Count Function In Group Footer

  • Thread starter Thread starter rmp
  • Start date Start date
R

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!
 
=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
 
Back
Top