Grouping in Report

[Charles G via AccessMonster.com]

I have a report with 691 clients with each assigned one Account Officer (AO).
There are 74 Account Officers. I currently have a query based report that
prompts for a [Enter Account Officer] parameter. If I want to print out a
list of clients for each Account Officer, I have to enter 74 different AO
names and this is just too time consuming.

Can I delete the parameter [Enter Account Officer] and do some type of
sorting and grouping in my report? I want each AO with their list of clients
on their own page, but do not want to have to enter a parameter value each
time.

Example:
Page 1
John Doe
A
B
C

Page 2
Jane Doe
Z
Y
X

-Charles-

 

[Amy Blankenship]

This has some concepts you may find useful
http://www.datapigtechnologies.com/flashfiles/topvaluespergroup.html

HTH;

Amy

 

[Duane Hookom]

You can use the sorting and group dialog in your report design. Use group
headers and/or footers and check out the Force New Page property of the
section.

 

[Charles G via AccessMonster.com]

Thanks for both responses.

Duane:
That's exactly what I needed

-Charles-