Assistance with "cc:" Carbon copy list of names.

[Robert Nusz @ DPS]

I have a Access 2003 front-end with DB/2 Back-end containing two tables.
Primary table name is TST_FR_CASE_RECORDS. This table has Primary key of two
joined fields: CASE_NUM_YR & CASE_NUM, format is four digit year value and 3
numeric digit case number as: yyyy###.
The secondary table is named TST_FR_CASE_OTHERS, with key based on joined
values of CASE_NUM_YR, CASE_NUM & SEQ_NUM. There is a one-to-many
relationship between these two tables, with master link of CASE_NUM_YR &
CASE_NUM.

If the records are as:

200400101 Lenny Thomas
200400102 Harry Williams
200400103 Mike Henry
200400104 Billy Joe
200400105 John Smith
200400106 Tom Thumb

I want to be able to add the names of all individuals involved in case to a
"cc" (carbon copy name list at the end of letter, and have these names
listed as:

cc: Lenny Thomas, Harry Williams, Mike Henry
Billy Joe, John Smith, Tom Thumb

NOT PRINT AS:

cc: Lenny Thomas
Harry Williams
Mike Henry
Billy Joe
John Smith
Tom Thumb

Is there a way to control and place this print in the first format as listed
above?

Thanks In Advance

 

[Duane Hookom]

There is a generic Concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.