adding information to groups on reports

  • Thread starter Thread starter Guest
  • Start date Start date
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!
 
Is the comments you asking for on a student by student basis or
Are the comments for math always the same, and for art always the same etc?

I'm going to assume the above.

Now for the department do you now have a combo box or table with the list of
possible department's ?

Assuming you have this table, then simply add a new field with the comments
into it

You can then build a query for the report and join in this additional table
and this additional field in to the report.

Then simply placed this additional field in the group by flipping below
although math comments.

if you have a good normalize database design for the above is really easy.

So simply add an additional field to the department table.
 
Back
Top