If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Query Help

Thread starter doucecool57
Start date Mar 23, 2013

doucecool57

New Member

Mar 23, 2013

I am attempting to create a query that uses a Employees (EmployeeID PK) table that is in relationship with a Projects table. The Projects table has a field which allows multiple values (Project Employees: "Able to assign multiple employees to the same project") When I query I am able to return the projects with the associated Employee ID but i would like to return the Name field from my Employee Table. When I add this related Name field rather than the Project Employee field this results in the Projects being separated into multiple entries. In short..I would like the results to return each individual project with the associated Employee Name listed in the same row.

Thanks,

Paul