Printing text data in a report

[Guest]

I have a client lis report in a database. I have sorted the data
Alphabetically and wish to print the report alphabetically, one page one
letter of the alphabet. is this possible?

 

[Allen Browne]

Open your report in design view.

Open the Sorting And Grouping dialog (View menu).

Select the name of the field to be sorted, e.g. Company.
In the lower pane of the dialog, set:
Group Header: Yes
Group On Prefix Characters
Group Interval 1

Access added a new Group Header to the report (grey bar in design view.)
Right-click it, and set this property:
Force New Page Before

The report now forces a new page before each new letter of the alphabet.

 

[Guest]

Allen

thanks for your help it now works fine.

Peter