Thank you for reading this question. I have two tables that looks like these:
EMPLOYEES EmpID Surname 100 Smith 200 Johnson PROJECTS EmpID Project 100 Road 100 Bldg 100 Hwy 200 Bridge 200 Tower Question: I would like to have a resultant table that will look like this: EmpID Project 100 Road, Bldg, Hwy 200 Bridge, Tower How will I do this please? Is this can be done via query or a program module? Please point me to ideas or examples.
