V
vanguardaccess
I have a report that is based on a query such as this:
LAST -- FIRST -- COURSE -- DEPT -- GRADE
Smith -- Jon -- Sculpture -- Art -- 79
Smith -- Jon -- Drawing -- Art -- 87
Smith -- Jon -- Algebra -- Math -- 100
Smith -- Jon -- Geometry -- Math -- 81
Smith -- Jon -- Calculus -- Math -- 65
I have created a report that groups these by Dept, so that Art courses are
together, Math, etc.
At the end of each section, I would like the report to have 1 row that
counts the number of courses with a grade of 65 and higher. For example, it
should say 2 (for Art courses) and 3 more Math courses. How can I do that?
Thanks!
--vanguardaccessman
LAST -- FIRST -- COURSE -- DEPT -- GRADE
Smith -- Jon -- Sculpture -- Art -- 79
Smith -- Jon -- Drawing -- Art -- 87
Smith -- Jon -- Algebra -- Math -- 100
Smith -- Jon -- Geometry -- Math -- 81
Smith -- Jon -- Calculus -- Math -- 65
I have created a report that groups these by Dept, so that Art courses are
together, Math, etc.
At the end of each section, I would like the report to have 1 row that
counts the number of courses with a grade of 65 and higher. For example, it
should say 2 (for Art courses) and 3 more Math courses. How can I do that?
Thanks!
--vanguardaccessman