counting records within a group

[Gibson-Mackey]

I'm creating a report to list and count records. My records are grouped by
school, then by student, then the visit detail is listed. I want to count
the visits by school, not necessarily by student.

I've created the invisible count in the detail and then a visible one that
should keep a running sum in the school group footer but it doesn't work. I
can get the count to work for the student footer (which I really don't need
to see but can live with) but the count isn't right for the school footer
whether I include the student level count or not.

Thank you very much.

Elizabeth

 

[Ayelet]

Hi,
I'm not sure exactly what you need, but it could be that
you need to use Sum() over the control count_by_student
instead of Count().
And it is possible that the best solution is simply to
count the records directly from the DB: set the control
source to something like
DCount("[VisitID]", "VisistsTbl", "[SchoolID] = " &
[SchoolID])
and it's Running Sum to No.
(this might be more complicated if your table's structure
is more complex, but still doable.)
HTH,
Ayelet