merge records into one field

[AnnPhil]

Can you write code in an unbound control that would merge data in a field from several records. ie. a subform has a field named "Owner", the subform has 3 records. I would like to put all 3 owners in one text box separated by a comma. Is this possible?

 

[Newman]

You could create a query in which you display the 3 fields and create another field and call it:
Owners:[Field#1]&", "&[Field#2]&", "&[Field#3]
Newman

 

[AnnPhil]

I understand how to concatanate fields but the problem is it isn't 3 fields its 3 records. ie, i have a table called contracts and another table called people. For every one contract there are many people tied to it. I have a mainform with a subform showing this info. After the names have been entered into the subform, I need to put all names from a contract into one field for the purpose of a mailmerge.
So if anyone knows a way to get this done i would appreaciate it. Thanks

 

[AnnPhil]

Thanks Pat, however when i went to the Knowledge base to look it up i got this message "Content that matches your query is not available at this time. However, Microsoft adds new documents regularly, and may provide information similar to what you are looking for in the future. "

Is there anyway i could get the information from another source? I need to work on this tomorrow. Thanks

 

[AnnPhil]

never mind i got it, Thanks for your help