Reports - page break

[mulletteeth]

I have a report sorted by 3 fields. I would like to have a page break
whenever the 1st field changes. I am somewhat new to Access so I hope
I am using the right terminology and explaining myself right.

 

[Allen Browne]

In report design view, open the Sorting And Groupging dialog.
Choose the first field.
In the lower pane, set Yes for the Group Header.
Access adds a group header section (gray bar) to the report.

Right-click that section, and choose Properties.
Set the Force New Page property to Before Section.

 

[mulletteeth]

Thanks for the help.

In report design view, open the Sorting And Groupging dialog.
Choose the first field.
In the lower pane, set Yes for the Group Header.
Access adds a group header section (gray bar) to the report.

Right-click that section, and choose Properties.
Set the Force New Page property to Before Section.