showing totals in reports

[Guest]

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

 

[Wolfgang Kais]

Hello vanguardaccessman.

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?

Display a group footer for the Dept group. in the Dept-Footer,
create a textbox with a ControlSource of
=Sum(Iif([GRADE]>=65,1,0))
That should do the job.