Access

[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

 

[Allen Browne]

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.