Access

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

Daniel Whitman

I have a database that I want to sortthe report alphabetically on seperate
pages
Example: all names starting with A on page 1
Names starting with B on page 2
 
Too easy:

1. Open the report in design view.

2. Open the Sorting And Grouping box.
Choose the field to sort on (e.g. Company Name.)
In the lower pane of the dialog, set:
Group Header Yes
Group On Prefix
Group Interval 1
This adds a Company Name header to the report, and the header will appear
whenever the 1st character changes, i.e. one for A, another for B.

3. Right-click the new Company Name Header section on the report, and choose
Properties. Set the Force New Page property to Yes. This gives you a new
page for each prefix letter.
 
Back
Top