Set up page breaks for reports at each alpha character.

[BrandyB]

I need help. I have created a roster for emloyees, but I want to start a new
page at each alpha character. For instance, when all the employees with a
last name that begins with "A" end. I want to start a new page before the
employees with the last name beginning with "B" begin. How do I accomplish
this?

 

[fredg]

I need help. I have created a roster for emloyees, but I want to start a new
page at each alpha character. For instance, when all the employees with a
last name that begins with "A" end. I want to start a new page before the
employees with the last name beginning with "B" begin. How do I accomplish
this?

Open the Report in Design View.
Click on View + sorting and grouping
In the Field/Expression column, write:
[EmployeeLastName]
or whatever the field name actually is.

In the lower panel select Group Header Yes.
Set the GroupOn to Prefix Characters
Set the Group Interval to 1 (which is the default anyway)

Save the change.
Then set the Group Header ForceNewPage property to BeforeSection.
It's on the Format tab of the property sheet.