Results 1 to 3 of 3
  1. #1
    razkowski is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2012
    Posts
    16

    report based on employee ID


    I'm trying to build employee commission statements as a report (confidential info obviously). So, I need to order the data based on employee ID. Further, I never want to have a page with more than one employee ID on it. So if employee #1 only takes up half of page 1, there would be a page break and employee #2 would start on page 2...etc. How can I accomplish this?

    Thanks

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    add a group footer for EmpID.
    drag a PAGE BREAK control into the footer. (on controls tab with the text box, checkboxes. To the right of the XYZ box)

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    your report will be using grouping (on empID). In the group footer insert a page break control or alternatively you can force new page - see this link https://support.office.com/en-us/art...7-846ae155cf9a

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

Similar Threads

  1. Replies: 15
    Last Post: 05-12-2017, 04:09 AM
  2. Replies: 2
    Last Post: 05-09-2017, 04:12 PM
  3. Replies: 15
    Last Post: 01-13-2013, 09:36 PM
  4. Replies: 8
    Last Post: 06-06-2012, 12:28 PM
  5. Email Payslip (report) to individual employee
    By batowiise in forum Reports
    Replies: 1
    Last Post: 11-09-2010, 05:08 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