Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

One record per each page of report

Status
Not open for further replies.

demon147

Technical User
Jun 29, 2001
30
CA
I want the report to only show the records of one single person on each page of the report.

Help appreciated.
 
Set the Sorting and Grouping on the ID for the individual persons and set the Force New Page option for the group. Joe Miller
joe.miller@flotech.net
 
Could you explain to me how to do this. Thanks very much.
 
in the design view you can choose the sorting and grouping option. on your toolbar its next to your toolbox button. click on that and then you can choose a field. you can then pick from a list of all fields as to what you want to group on. pick your identifier for the person and then below that you can choose if you want a group header and footer. Select yes to them. then click on the group header or footer itself and go to its properties, then you can select on the "force new Page" option either before, after, or both. Usually you choose befor section in the header and after section in the footer. hope this helps
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top