Results 1 to 4 of 4
  1. #1
    kagoodwin13 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Feb 2012
    Posts
    181

    Generate Separate Pages Based On Grouped Field


    Hello! I am doing a report where the customer would like to generate 52 unpaid invoices on 52 separate pages. The report is mostly developed. I am attempting to separate the pages by OrderID. I have a header section for OrderID, and have attempted to toggle the Force New Page characteristic, but no luck.

    Thanks for any help you can provide!

    Design
    Click image for larger version. 

Name:	Access1.jpg 
Views:	15 
Size:	191.0 KB 
ID:	27139

    Output
    Click image for larger version. 

Name:	Access2.jpg 
Views:	15 
Size:	117.8 KB 
ID:	27140

    Desired Output
    Click image for larger version. 

Name:	Access3.jpg 
Views:	16 
Size:	131.7 KB 
ID:	27141

  2. #2
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    I'm no expert on reports but shouldn't the force new page be on the detail section?


    Sent from my iPhone using Tapatalk

  3. #3
    AccessPower's Avatar
    AccessPower is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Oct 2016
    Posts
    165
    Yes. There is an item on the property sheet that you can edit called "Force New Page". Set that to before section on the group header.

    Also, note that the page separation will not happen in report view. It will, however, happen in print preview and while printing.

  4. #4
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    There is a setting in Group & Sort where you set page before/after.

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

Similar Threads

  1. Replies: 3
    Last Post: 07-20-2015, 10:45 AM
  2. How to generate unique id based on another field
    By blyzz in forum Programming
    Replies: 6
    Last Post: 04-09-2015, 04:13 PM
  3. Replies: 9
    Last Post: 08-11-2014, 01:24 AM
  4. Replies: 9
    Last Post: 06-26-2013, 08:28 AM
  5. Replies: 1
    Last Post: 08-31-2011, 04:03 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