Counting on Report

  • Thread starter Thread starter Janine
  • Start date Start date
J

Janine

I have a report that first groups by Program name with all
the clients listed under each program. Looks great.
there is a field in the report called Location and there
is only two possible locations. Is there a way to perform
a calculated count at the bottom of my report, i.e. how
many clients are north and how many clients are south
without grouping them? I want this to be over the entire
report, not just program specific.
 
In the Query that you use as RecordSource, include two Calculated Fields,
something line NorthCount: IIF ([Location]) = "N", 1,0) and SouthCount: IIF
([Location]) = "N", 1,0). Sume each of these in the Report footer and I
believe you'll have what you want.

Larry Linson
Microsoft Access MVP
 
Back
Top