Help with grouping

[madhatter]

Im a teacher trying to use access to create progress reports for my students. I have it grouped by student name and then under each student name is the class name and their assignment scores. It worked last year when i taught 5 sections of the same course. But this year I teach two different courses. I have students that are in BOTH courses. Instead of having a different section for each class, under each student only the first class they are in is named, then assignments from BOTH classes without any seperation between the two classes.

The report looks like this:

Student Name
Class Name1
Assignments from BOTH classes

I want it to look like this for students in both of my courses:
Student name
Class Name 1
Assignments from class 1
Class Name 2
Assignments from class 2

Can anybody tell me where my grouping error is?

 

[jzwp22]

Out of curiosity, what does your table structure look like? It sounds like you need to also add a group level for course within student, but that will only work if your tables are set up properly.

 

[Kafrin]

As jzwp says, it depends how your tables are set up.

Starting from scratch, you'd set up a table for Students, a table for Classes and a 'mapping' table (which I'll call StudentClassMap) which links to both Students and Classes to show which students take which classes. You'd then base your report on StudentClassMap and group first by student and then by class.

If instead you have the class info on the same table as the student info, did you (a) add fields for the second class or (b) create another record for the student? If (a), you don't need grouping, just show all the fields. If (b), just group by student and put the class/assignment fields in the detail.