Keeping data together across pages in a report

  • Thread starter Thread starter pruckelshaus
  • Start date Start date
P

pruckelshaus

I have an Access 2007 report. It displays counts of students by graduation
year, and is grouped by teacher...something like this:

Teacher name
2010 3
2011 4
2012 3
2013 3
Total: 13

There are 85 teachers, so the report spans a dozen or so pages. Now, even
though I have "Keep together" selected in the property sheet of each section
of my report, there are page breaks in the middle of each section. How do I
absolutely, positively force everything between "teacher name" and "total" to
stay together on teh same page without forcing a page break after each
teacher's section?

Thanks

Pete
 
In report design view, open the Sorting And Grouping pane, and select the
group based on the Teacher field.

You will see an option in the Sorting'n'Grouping pane (not in the Properties
box), for:
Keep whole group together on one page.
 
Group by teacher name and then set the group's Keep Together property to Whole
Group.

You set the grouping using the Sorting and Grouping Dialog (View: Sorting and
Grouping ...)

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top