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,