concatenate multiple child records into a single value

concatenate multiple child records into a single value is project number 274681 posted at GetAFreelancer.com. Click here to post your own project.

Status:	Closed (Project expired)
Selected Providers:	-
Budget:	$30-250
Created:	06/14/2008 at 18:19 EDT
Bidding Ends:	06/19/2008 at 18:19 EDT
Project Creator:	Mr2006   Buyer Rating: (1 reviews)
Description:	I have a query made from 5 tables Events_tbl and activity_tbl. The relationship is one-many. on a monthly basis, I prepare a report for the month events. I want instead of having each traveler's name in one row, I want to be able to group all the travelers in few rows. to be clear, the report now is about 15-20 pages. because one trip may have 8 travelers or more. I want to reduce space andf paper. I want to have the names one after the other example: Trip to Italy Travelers:(John Smith, Steve James, Mark Edward) Right now, it will show like this: Trip to Italy Travelers: John Smith Steve James Mark Edward Can this be done? Thanks
Job Type:	Visual Basic
Database:	MS Access
Operating system:	MS Windows
Bid count:	14
Average bid:	$ 42