Access 2016 report grouping problem

Question

Summary: I'm having trouble getting a report to list/print ALL the student records of a teacher who has more students than can fit on one page.

The query includes the following:

Teacher name

Student name

Student's performance date

Student's performance order (number from 1 to 6 or so)

I want the report to list each teacher's students by grouped by performance date, sorted by performance time and then sorted by performance order, followed by a page break to begin another teacher.

I have it grouping by teacher, with a header and a page break in the teacher group footer. Then sorted by date, and finally sorted by performance order number. I've also tried grouping by day but that doesn't seem to help.

It works fine, as long as a teacher doesn't have more students that what would fit on a page. It's not printing the second page. So, if a teacher has say, 50 students performing on 6/1/2016 the report will list one page's worth (about 30 records) and then start a new page with a new performance day (leaving off the remainder of the records for 6/1/2016).

I've tried grouping and sorting in just about every combination possible, but I haven't hit on the one that works. Any help would be appreciated.

Thanks in advance.

Jerry

Answer 1

I was able to fix the problem by re-starting from scratch and using the report wizard. I haven't scrutinized the new one thoroughly to see what's different, but my initial review didn't show any obvious difference. Strange, but at least I have it working now.

Jerry

Answer 2

That's unusual. But your report is not. I would think you need to group by Teacher, then sort by Performance Date and order.

Make sure your break is AFTER the Teacher footer.

Answer 3

Hard to say without you posting a test db.

I would run the Report Wizard and try again.