showing totals in reports

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top