Results 1 to 2 of 2
  1. #1
    Donnydon is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    Sep 2011
    Posts
    1

    Page Header & Forced Page Break

    Hi
    I am very new to Microsoft Access and am self learning.
    I have a report that I would like to generate on a query previously done (Customers, Orders & Products).

    I would like to have the 'Customers Name' followed by Text of 'Monthly Exceptions' in the page header. The idea is that each new page would have a new customer name and all orders for that customer on it. I have tried a text box but this won't update the customer name an all pages.



    Also I know how to force a page break but I don't know where in Design View is should be inserting it to get a new customer and their orders on the next page?

    Any advice would be greatly appreciated.
    Thanks

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    Put your page break in the CUSTOMER FOOTER after any subtotaling or other fields that are in the customer footer section.

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

Similar Threads

  1. Replies: 3
    Last Post: 08-07-2011, 09:22 PM
  2. Page Break in Report Headers
    By JonathanT in forum Reports
    Replies: 8
    Last Post: 06-30-2011, 10:37 PM
  3. Forced page breaks - I know really something quite simple
    By kw@officeadminsolutions in forum Reports
    Replies: 3
    Last Post: 05-16-2011, 12:17 AM
  4. page break problem
    By simba in forum Reports
    Replies: 0
    Last Post: 11-30-2010, 10:39 AM
  5. Page break on report inserts empty page between
    By Galadrielle in forum Reports
    Replies: 0
    Last Post: 07-07-2010, 04:18 AM

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