How can I keep my Groups together in my Access 2007 Reports? In short, in the Design view of the Report, go to the Design Tab on the Ribbon, and then in the Grouping & Totals group click on the Group and Sort button. Below in the Sorting and Grouping pane click on Add a Group button and choose the field you wanted grouped. Once set then you'll see the field in the pane, where you can expand that "line item" to reveal more options with sorting and grouping that field, which includes setting the option of say, "do not keep group together on one page" to "keep whole group together on one page". See our Microsoft Certified Trainer show you how easy it is!

Purchase the training video and you can see this in action for yourself!