Hi Bea,

Does the Query show the correct number of records per student?
Do you have show each record on new page?
Does the report have multiple pages that you can scroll through?

You may need to look into Sorting and Grouping in Reports:

1. How to use a Sorting & Grouping Level to group by Year.
2. Using Sorting & Grouping Levels in Access 2010.
3. Learn how to use Sorting & Grouping Levels in your Access Reports.

Alex