Feb 23, 2010; 08:16
Michael Gilman
Subsummary
Hey gang,
I am having a brain freeze moment. Please help if you can.
I have a table that contains Attendance information, such attendance
id (primary key), student id, student name, session id, date attended,
siteid, etc.
What I am trying without success is to have a count of the students
per site, what I keep getting is how many days they attended by site,
I know I am missing something.
I have tried counts on student id, student name, site and
attendanceid, none of which worked.
I would like the report to look like:
Program (sub summary) ICT
Site (sub summary ) CCA student count = 3
Student (sub summary) John Doe
Jane Doe
Peter Paul
But what I am getting is:
Program (sub summary) ICT
Site (sub summary ) CCA student count = 25 (which is the number
of classes everyone in this group attended)
Student (sub summary) John Doe
Jane Doe
Peter Paul
Any direction would be appreciated.
Thanks
Michael Gilman
--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/