G
Guest
I have reports that are grouped by department. Here is some example data:
Name ----- Dept ----- Course ----- Grade
John ----- Math ----- Algebra ---- 75
John ----- Math ----- Geometry --- 80
John ------ Art ------ Painting ---- 77
John ------ Art ------ Sculpture -- 99
I've figured out how to count the number of courses per group and put that
total under each group. To extend upon this, I would like to write something
unique about each particular department in the report. For example, for the
math group I would like to write you must pass 8 courses. For the Art group,
I would like to write you must pass 6 courses.
How can I do that?
Thanks!
Name ----- Dept ----- Course ----- Grade
John ----- Math ----- Algebra ---- 75
John ----- Math ----- Geometry --- 80
John ------ Art ------ Painting ---- 77
John ------ Art ------ Sculpture -- 99
I've figured out how to count the number of courses per group and put that
total under each group. To extend upon this, I would like to write something
unique about each particular department in the report. For example, for the
math group I would like to write you must pass 8 courses. For the Art group,
I would like to write you must pass 6 courses.
How can I do that?
Thanks!