Results 1 to 5 of 5

Thread: Page Breaks

  1. #1
    Join Date
    Oct 2005
    Posts
    55

    Unanswered: Page Breaks

    Hi I am getting stright to it!

    I have created a report that show the amount of jobs done in a paticular 'Area' for a week!

    I have sorted the report by the 'Area' but what I want to do also is to have a page break for the 'Area' generated.

    So for example say for the week work was done in Snapple Area 4 time for the week with different information for each time the area was visited and in Dark Area 3 time for that same week with different information for each time the area was visited.

    I want the page to break at the end of the last information generated for the 'Snapple Area' and then continue with the information for 'Dark Area' until it reaches the last information for 'Dark Area' and so on and so on!

    I am not to sure if a page break is what I need to use. So if there is another method that I can use to do this?

    Thanks for the help!

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Try putting a Hard page break in your header or footer ...
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Yup, you're on the right track. What you want to do is create a section footer and select "force new page" for that section.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  4. #4
    Join Date
    Oct 2005
    Posts
    55
    Thanks M Owen and Teddy!

    I have one more question! how do I show the total records found for a paticular areas.

    So for example say for the week work was done in Snapple Area 4 time for the week with different information for each time the area was visited and in Dark Area 3 time for that same week with different information for each time the area was visited.

    I want the page to break at the end of the last information generated for the 'Snapple Area' also generate the total that 4 times work was done in that area,and then continue with the information for 'Dark Area' until it reaches the last information for 'Dark Area' generating total work in that area and so on and so on!

    Thanks!

  5. #5
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Put summary total controls in your footer(s) to display that ... Bind each textbox to the desired column to sum on ... Set your ControlSource to: =Sum([WhatEverMyColumnNameIs])
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •