sorting record section on new pages

  • Thread starter Thread starter Daniel Whitman
  • Start date Start date
D

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
 
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.
 
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
 
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.)
 
Back
Top