How to create a page break in access 2007 reports?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mfuentes74
    New Member
    • Sep 2009
    • 5

    How to create a page break in access 2007 reports?

    Hi! I need help I have a report in Access 2007 and I need to insert a page break after every operator id (kn028mf) the first five characters are the same only the last two change, I have tired forcing page break but it prints each one on a separate page,microsoft states I need to create a macro or event procedure but have no idea how to do that, any help would be great. :)
  • topher23
    Recognized Expert New Member
    • Oct 2008
    • 234

    #2
    Where were you forcing the page break when you tried this earlier?

    It sounds like the issue may be in your sorting and grouping for the report. Make sure you're grouping first by operator (with header/footer turned on), then by whatever other criteria you want to sort by. If you force a new page after the operator section, it should do what you want.

    Comment

    • mfuentes74
      New Member
      • Sep 2009
      • 5

      #3
      thanks that worked. :)

      Comment

      Working...