Found this forum when googling for some answers to a problem Im having, hopefully someone here can help.

Ive got a report that is meant to display a subject and a grade for each subject each student takes. Each student takes a different amount of classes.

The page header is the student's name, and in the body of the report I have simply:

Subject | Grade

And thats it.

However, as well as displaying the Subject / Grades for the current student, it also pulls a couple of subject and grades from the next student, and then at the bottom of the page where it also shows the students name, it is that of the next student.

I cant figure out what Im doing wrong.. Any ideas? Thanks

Without seeing your db it is difficult to be specific about the exact cause.

Possible solutions would be along the lines of making sure your report is based on a query that is showing the correct information. Also check the grouping and sorting in your report design. It would seem that 1 section starting on a new page for each student is what you are looking for.

Yep 1 student on a new page is what Im looking for. The underlying query works fine. I think it must be something wrong with the report itself as trying to print it crashes Access. All other reports print ok.

I will have a read about grouping / sorting. I hadnt set anything for that. Thanks.