Results 1 to 2 of 2
  1. #1
    newtoAccess is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    226

    forceing groups to next page

    In a report I have several groups.
    Some of the group data spans over to the next page with out a group headder or with just one line on the next page or with just one line on the previous page.



    Is there a way to force a group to the next page if it does not fit on the previous page? I have no groups that wil be greater than 1 page. How ever I have may groups that will fit 3 or 4 on a page. If I print individule group pages it is a wate of paper as there may be one item in the group.

    So If I get 4 groups on one page and the 4th group spans to the next page how do I get the entire 4th group to jump to the next page?

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    yes, there is a 'Keep Together' property. Look into the Sorting/Grouping in View when in Design View of a report. Or look up this aspect of Report design in your Access textbook for further instructions.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. DSum in Query - Adding groups
    By Huddle in forum Queries
    Replies: 1
    Last Post: 02-04-2011, 07:53 PM
  2. Page break on report inserts empty page between
    By Galadrielle in forum Reports
    Replies: 0
    Last Post: 07-07-2010, 04:18 AM
  3. Query showing averages for groups
    By AnthonyTesta in forum Queries
    Replies: 1
    Last Post: 02-03-2010, 09:04 PM
  4. Group & Reports (more than 4 Groups??)
    By JohnS in forum Reports
    Replies: 3
    Last Post: 10-01-2009, 07:11 AM
  5. using date for groups
    By antcox2004 in forum Reports
    Replies: 3
    Last Post: 01-28-2006, 07:44 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums