Combine Child records in a report

[gregch]

I have a report that I would like to have print several child records on a line. These records happen to be names and the way I want them to print is as follows ("First name" "Last name", "First Name" "Last Name") There could be as many as 4 names that I would like to print on one line. Is there an easy way of querying the information and placing it into the report? Any help would be greatly appreciated!

 

[pbaldy]

http://www.mvps.org/access/modules/mdl0004.htm

or

http://support.microsoft.com/kb/210163/en-us

 

[datAdrenaline]

I would suggest the code found by Clicking Here you can pass an SQL statement to it and it will concatenate the records into a string. You will have to be deligent when creating the passed SQL in order to have the data you want. If you need help with that step, we will need to know more about the data and how its structured.

EDIT ...
Sorry for any dup info ... I was in the edit buffer too long!!

 

[gregch]

Thanks for the responses! I was able to get this to work using Paul's suggestion.

Greg