Reports on seperate pages

Use the Sorting and Grouping dialog box. You get to that dialog box while the report is in Design view, then use the View Menu, and the Sorting and Grouping option is about 1/2 the way down. In the Field/Expression column, select StudentID. In the area at the bottom of this dialog box, change Group Heder to "Yes". Then on your report in design view, click on the StudentID and open the property sheet, if not already open. You can use the F4 key to open (or close) the propery sheet. On the property sheet, Format tab, you can change the "Force New Page" property to "Before Section"
 
Thanks for your help. I apprecaite it! :)
 

Users who are viewing this thread

Back
Top Bottom