counting records within a group

  • Thread starter Thread starter Gibson-Mackey
  • Start date Start date
G

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