Results 1 to 4 of 4
  1. #1
    dRAGZOR is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2020
    Posts
    6

    Creating a report that has a sperate page for a multivalue field


    Hello to allow the Access Wizards out there,

    Im looking for some guidence on making a report that prints out each project that a employee is working on. Currently we have a table of projects with and employees are added to the project through a multivalued cell. When I created a report to do this instead of having a page of each employee it list all the jobs that only "John Doe" is on and list all the jobs the only "John Doe" and "Dave Mayer" work on together. I would like it to duplicate projects to show up on each employee list if multiple people are working on the same job.

    Thank you,

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    create a group footer for the Mult field.
    in the footer add the PAGE BREAK control (looks like an ellipsis)

    then you get a new page for each.

  3. #3
    dRAGZOR is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2020
    Posts
    6
    Quote Originally Posted by ranman256 View Post
    create a group footer for the Mult field.
    in the footer add the PAGE BREAK control (looks like an ellipsis)

    then you get a new page for each.
    now there is a new page for each but if I have Dave Mayer and John doe on the same project they show up on a separate page together.

  4. #4
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I would like it to duplicate projects to show up on each employee list
    Sounds to me like you are grouping on 'job' but you should be grouping on 'employee'. However that will also associate jobA with Joe and jobA with Sam and not jobA with (Sam and Joe).
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Multivalue field on a Report
    By JonathanT in forum Reports
    Replies: 1
    Last Post: 07-13-2016, 09:45 AM
  2. Replies: 2
    Last Post: 02-04-2016, 08:13 AM
  3. Creating PDF for each page of a report?
    By g4tv4life in forum Programming
    Replies: 8
    Last Post: 01-30-2014, 05:08 PM
  4. Creating Summary Page in Access Report
    By jakeman in forum Reports
    Replies: 5
    Last Post: 10-11-2011, 06:25 PM
  5. Creating an HTML report as a single page
    By Harle in forum Access
    Replies: 2
    Last Post: 01-22-2011, 11:18 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