Grouping in Report

  • Thread starter Thread starter Charles G via AccessMonster.com
  • Start date Start date
C

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-
 
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.
 
Thanks for both responses.

Duane:
That's exactly what I needed :)

-Charles-
 
Back
Top