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!

Page breaking

Status
Not open for further replies.

Sylvialn

IS-IT--Management
Dec 28, 2000
101
US
I have a form with an option group with 8 option buttons. The first options is the primary key and choices 2-8 are other fields. If a user selects option 1 (primary key) to sort by, it opens a report based off of a simple query and feeds the information in order by the option group selection. should the user select #'s 2-8 to sort by, it will sort by the user's choice (#2-8) and then by option 1. I am having trouble figuring out how to page break after each sort(keep all #2 sorted and on same page). For example, a user selects #2 (sort by team). I have the report opening up the list sorted by #2 (team) and then by #1 (id number). I would like it to page break after each different #2 (every team grouped together on same page - new team, new page). I have tried using a page break module, but I cannot get it to work. i have attempted the keeptogether property & can't get it to work. Can anyone offer a solution?
 
The straight forward (if convolouted) appraoch would be to open the report in design mode - hidden and set he sorting grouping criteria. Switch the report to Preview mode and all should be "wonderful".


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top