Query question 2

[Bkenney228]

Here is my problem, I hope someone out there can help...

I have a table with a list of assignments, and a table with a list of resources. Each assignment in my table will have at least 2 resources assigned. I am trying to build a query that will display the assignment and the assigned resource. currently when I run my query I get the following output:

Assignment | Resource
334142 | Jane Doe
334142 | Jon Doe

The output I am looking for is:

Assignment | Resource
223142 | Jane Doe, Jon Doe

Does anyone out there have an idea on how I get the desired output? Any info would be greatly appreciated.

Thanks for your time

 

[fneily]

See
faq701-3499

 

[PHV]

Have a look here: faq701-4233

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886