sorting record section on new pages

[Daniel Whitman]

I am trying to sort an Access report by last name with name sections on
seperate pages.

Example: Apple, Adams Page 1
Bark, Ball Page 2 ect.

Also trying to create a header for each page such as A,B, C

 

[Allen Browne]

In report design view, open the Sorting And Grouping dialog.

Select the field that contains the name.
Choose Yes for Group Header (so Access puts a group header on the report.)
Set the interval to 1 prefix character.

Now select the new group header, and set its Force New Page to:
Before Section

This gives you a new page every time the first letter of the name changes.

 

[Daniel Whitman]

Thank you for your help however your suggestion worked but it put each
record on a separate page what I am looking for it to put all last names that
start with a on page 1 and all names that start with b on page 2 ect

 

[Allen Browne]

You did not set the prefix character to 1 in the sorting'n'grouping dialog.

That will cause the page break only after the first character changes (e.g.
the first character changes from A to a B.)