Results 1 to 5 of 5
  1. #1
    dssrun is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Oct 2010
    Posts
    83

    Page Breaks and the Report Footer


    I have a page break in a Footer that is Grouped by Month. However, after the last group I want the grand total to display right after it on the same page (the grand total is in the Report Footer). As of now the grand total is just one line on a new page. Is there a way to accomplish this?

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    it's probably one line on a new page because the report is just the right length to be "annoying". there's nothing you can do about that, right?

    try tweeking the report's properties? fonts? footer sizes? page break coordinates? things like that maybe? The report footer comes at the end of everything...regardless. (I think)

  3. #3
    dssrun is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Oct 2010
    Posts
    83
    I am not sure if that is it, I tried shrinking font etc.. The last group only cover 1/4 of the page

  4. #4
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    those are my only ideas, sir.

  5. #5
    dssrun is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Oct 2010
    Posts
    83
    Quote Originally Posted by ajetrumpet View Post
    those are my only ideas, sir.
    Hm, well I will have to play around with it, just wanted to see if anyone had a quick answer, I appreciate the help as always. I will let you know if I figure something out

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

Similar Threads

  1. Page breaks
    By berni3883 in forum Reports
    Replies: 0
    Last Post: 03-31-2011, 01:25 PM
  2. Figure Numbers incrementing over Page Breaks
    By jezzamax in forum Reports
    Replies: 3
    Last Post: 12-19-2010, 08:05 PM
  3. Page Breaks. Is there a way to do it?
    By newtoAccess in forum Reports
    Replies: 8
    Last Post: 11-30-2010, 01:02 PM
  4. Page Footer
    By jamil_kwi in forum Access
    Replies: 1
    Last Post: 05-31-2010, 04:02 AM
  5. Replies: 0
    Last Post: 02-11-2009, 06:43 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