R
RNUSZ@OKDPS
I have a query built as follows:
SELECT TST_FR_CASE_RECORDS.CASE_NUM_YR, TST_FR_CASE_RECORDS.CASE_NUM,
TST_FR_CASE_RECORDS.PRTD_CDE, TST_FR_CASE_RECORDS.TYPIST_INIT_TXT,
TST_FR_USER_TABLE.USER_NME, TST_FR_CASE_RECORDS.ACC_DATE,
TST_FR_CASE_RECORDS.HRG_DATE, TST_FR_CASE_RECORDS.HRG_TIME_TXT,
TST_FR_CASE_RECORDS.HRG_AM_PM_TXT, TST_FR_CASE_RECORDS.LOC_CDE,
TST_FR_HEARING_LOC.LOC_NME, TST_FR_HEARING_LOC.CITY_NME,
TST_FR_HEARING_LOC.STATE_CDE, TST_FR_HEARING_LOC.ROOM_NME,
TST_FR_HEARING_LOC.MEMO_TXT, TST_FR_CASE_RECORDS.LIC_FIRST_NME,
TST_FR_CASE_RECORDS.LIC_MIDDLE_NME, TST_FR_CASE_RECORDS.LIC_LAST_NME,
TST_FR_CASE_RECORDS.LIC_ADDR_TXT, TST_FR_CASE_RECORDS.LIC_CITY_NME,
TST_FR_CASE_RECORDS.LIC_STATE_CDE, TST_FR_CASE_RECORDS.LIC_ZIP_CDE,
TST_FR_CASE_RECORDS.DOA_NME, TST_FR_CASE_RECORDS.DOA_ADDR_TXT,
TST_FR_CASE_RECORDS.DOA_CITY_NME, TST_FR_CASE_RECORDS.DOA_STATE_CDE,
TST_FR_CASE_RECORDS.DOA_ZIP_CDE, TST_FR_CASE_RECORDS.FLAG_CDE,
TST_FR_CASE_RECORDS.BATCH_DATE, TST_FR_CASE_RECORDS.BATCH_NUM,
TST_FR_CASE_OTHERS.SEQ_NUM, TST_FR_CASE_OTHERS.OTHER_NME,
TST_FR_CASE_OTHERS.FIRM_NME, TST_FR_CASE_OTHERS.OTHER_ADDR_TXT,
TST_FR_CASE_OTHERS.OTHER_CITY_NME, TST_FR_CASE_OTHERS.OTHER_STATE_CDE,
TST_FR_CASE_OTHERS.OTHER_ZIP_CDE, TST_FR_CASE_RECORDS.ATTY_NUM,
TST_FR_ATTORNEY.FIRST_NME, TST_FR_ATTORNEY.MIDDLE_NME,
TST_FR_ATTORNEY.LAST_NME, TST_FR_ATTORNEY.SUBTITLE_TXT,
TST_FR_ATTORNEY.FIRM_NME, TST_FR_ATTORNEY.ADDR1_TXT,
TST_FR_ATTORNEY.ADDR2_TXT, TST_FR_ATTORNEY.CITY_NME,
TST_FR_ATTORNEY.STATE_CDE, TST_FR_ATTORNEY.ZIP_CDE
FROM (((TST_FR_CASE_RECORDS INNER JOIN TST_FR_ATTORNEY ON
TST_FR_CASE_RECORDS.ATTY_NUM = TST_FR_ATTORNEY.ATTY_NUM) INNER JOIN
TST_FR_CASE_OTHERS ON (TST_FR_CASE_RECORDS.CASE_NUM_YR =
TST_FR_CASE_OTHERS.CASE_NUM_YR) AND (TST_FR_CASE_RECORDS.CASE_NUM =
TST_FR_CASE_OTHERS.CASE_NUM)) INNER JOIN TST_FR_HEARING_LOC ON
TST_FR_CASE_RECORDS.LOC_CDE = TST_FR_HEARING_LOC.LOC_CDE) INNER JOIN
TST_FR_USER_TABLE ON TST_FR_CASE_RECORDS.TYPIST_INIT_TXT =
TST_FR_USER_TABLE.TYPIST_INIT_TXT
WHERE (((TST_FR_CASE_RECORDS.CASE_NUM_YR)=2004) AND
((TST_FR_CASE_RECORDS.CASE_NUM)=75))
ORDER BY TST_FR_CASE_OTHERS.SEQ_NUM;
I want to take the fields named:
field a) TST_FR_CASE_RECORDS.LIC_FIRST_NME, (temp value of Linda)
field b) TST_FR_CASE_RECORDS. LIC_MIDDLE_NME, (temp value of Z.)
field c) TST_FR_CASE_RECORDS. LIC_LAST_NME, (temp value of Zane)
field d) TST_FR_CASE_RECORDS.DOA_NME, (temp value of Zackery Zones)
field e) TST_FR_ATTORNEY.FIRST_NME, (temp value of John)
field f) TST_FR_ATTORNEY.MIDDLE_NME, (temp value of Jay)
field g) TST_FR_ATTORNEY.LAST_NME, (temp value of Smith)
record 1 with
field h) TST_FR_CASE_OTHERS.OTHER_NME, (temp value of Willa Thomas)
field i) TST_FR_CASE_OTHERS.FIRM_NME, (temp value of Williams & Williams)
record 2 with
field h) TST_FR_CASE_OTHERS.OTHER_NME, (temp value of Tommy Smith)
field i) TST_FR_CASE_OTHERS.FIRM_NME, (temp value of Smith & Smith)
record 3 with
field h) TST_FR_CASE_OTHERS.OTHER_NME, (temp value of Larry Lemons)
field i) TST_FR_CASE_OTHERS.FIRM_NME, (temp value of Lemons & Limes)
and spill them out to a single grouped output area for cc: (carbon Copy) such
cc: Linda Z. Zane, Zackery Jones, John Jay Smith, Willa Thomas - Williams &
Williams.
Tommy Smith - Smith & Smith, Larry Lemons - Lemons & Limes
I feel the output field would have to be unbound text box, with can grow and
can shrink enabled yes. Records in the query look like
The resulting query has 3 records in it. Each record in this quiry has
Fields a, b, c, d, e, f, g in it with same names,
but record 1 has Willa Thomas, Williams & Williams
record 2 has Tommy Smith - Smith & Smith
record 3 has: Larry Lemons - Lemons & Limes
What do I have to do to concatenate all names in one output area for form
letter for cc purposes.
Thanks,
key field
01 - Zinda Z.Zane, Zack Zones,
SELECT TST_FR_CASE_RECORDS.CASE_NUM_YR, TST_FR_CASE_RECORDS.CASE_NUM,
TST_FR_CASE_RECORDS.PRTD_CDE, TST_FR_CASE_RECORDS.TYPIST_INIT_TXT,
TST_FR_USER_TABLE.USER_NME, TST_FR_CASE_RECORDS.ACC_DATE,
TST_FR_CASE_RECORDS.HRG_DATE, TST_FR_CASE_RECORDS.HRG_TIME_TXT,
TST_FR_CASE_RECORDS.HRG_AM_PM_TXT, TST_FR_CASE_RECORDS.LOC_CDE,
TST_FR_HEARING_LOC.LOC_NME, TST_FR_HEARING_LOC.CITY_NME,
TST_FR_HEARING_LOC.STATE_CDE, TST_FR_HEARING_LOC.ROOM_NME,
TST_FR_HEARING_LOC.MEMO_TXT, TST_FR_CASE_RECORDS.LIC_FIRST_NME,
TST_FR_CASE_RECORDS.LIC_MIDDLE_NME, TST_FR_CASE_RECORDS.LIC_LAST_NME,
TST_FR_CASE_RECORDS.LIC_ADDR_TXT, TST_FR_CASE_RECORDS.LIC_CITY_NME,
TST_FR_CASE_RECORDS.LIC_STATE_CDE, TST_FR_CASE_RECORDS.LIC_ZIP_CDE,
TST_FR_CASE_RECORDS.DOA_NME, TST_FR_CASE_RECORDS.DOA_ADDR_TXT,
TST_FR_CASE_RECORDS.DOA_CITY_NME, TST_FR_CASE_RECORDS.DOA_STATE_CDE,
TST_FR_CASE_RECORDS.DOA_ZIP_CDE, TST_FR_CASE_RECORDS.FLAG_CDE,
TST_FR_CASE_RECORDS.BATCH_DATE, TST_FR_CASE_RECORDS.BATCH_NUM,
TST_FR_CASE_OTHERS.SEQ_NUM, TST_FR_CASE_OTHERS.OTHER_NME,
TST_FR_CASE_OTHERS.FIRM_NME, TST_FR_CASE_OTHERS.OTHER_ADDR_TXT,
TST_FR_CASE_OTHERS.OTHER_CITY_NME, TST_FR_CASE_OTHERS.OTHER_STATE_CDE,
TST_FR_CASE_OTHERS.OTHER_ZIP_CDE, TST_FR_CASE_RECORDS.ATTY_NUM,
TST_FR_ATTORNEY.FIRST_NME, TST_FR_ATTORNEY.MIDDLE_NME,
TST_FR_ATTORNEY.LAST_NME, TST_FR_ATTORNEY.SUBTITLE_TXT,
TST_FR_ATTORNEY.FIRM_NME, TST_FR_ATTORNEY.ADDR1_TXT,
TST_FR_ATTORNEY.ADDR2_TXT, TST_FR_ATTORNEY.CITY_NME,
TST_FR_ATTORNEY.STATE_CDE, TST_FR_ATTORNEY.ZIP_CDE
FROM (((TST_FR_CASE_RECORDS INNER JOIN TST_FR_ATTORNEY ON
TST_FR_CASE_RECORDS.ATTY_NUM = TST_FR_ATTORNEY.ATTY_NUM) INNER JOIN
TST_FR_CASE_OTHERS ON (TST_FR_CASE_RECORDS.CASE_NUM_YR =
TST_FR_CASE_OTHERS.CASE_NUM_YR) AND (TST_FR_CASE_RECORDS.CASE_NUM =
TST_FR_CASE_OTHERS.CASE_NUM)) INNER JOIN TST_FR_HEARING_LOC ON
TST_FR_CASE_RECORDS.LOC_CDE = TST_FR_HEARING_LOC.LOC_CDE) INNER JOIN
TST_FR_USER_TABLE ON TST_FR_CASE_RECORDS.TYPIST_INIT_TXT =
TST_FR_USER_TABLE.TYPIST_INIT_TXT
WHERE (((TST_FR_CASE_RECORDS.CASE_NUM_YR)=2004) AND
((TST_FR_CASE_RECORDS.CASE_NUM)=75))
ORDER BY TST_FR_CASE_OTHERS.SEQ_NUM;
I want to take the fields named:
field a) TST_FR_CASE_RECORDS.LIC_FIRST_NME, (temp value of Linda)
field b) TST_FR_CASE_RECORDS. LIC_MIDDLE_NME, (temp value of Z.)
field c) TST_FR_CASE_RECORDS. LIC_LAST_NME, (temp value of Zane)
field d) TST_FR_CASE_RECORDS.DOA_NME, (temp value of Zackery Zones)
field e) TST_FR_ATTORNEY.FIRST_NME, (temp value of John)
field f) TST_FR_ATTORNEY.MIDDLE_NME, (temp value of Jay)
field g) TST_FR_ATTORNEY.LAST_NME, (temp value of Smith)
record 1 with
field h) TST_FR_CASE_OTHERS.OTHER_NME, (temp value of Willa Thomas)
field i) TST_FR_CASE_OTHERS.FIRM_NME, (temp value of Williams & Williams)
record 2 with
field h) TST_FR_CASE_OTHERS.OTHER_NME, (temp value of Tommy Smith)
field i) TST_FR_CASE_OTHERS.FIRM_NME, (temp value of Smith & Smith)
record 3 with
field h) TST_FR_CASE_OTHERS.OTHER_NME, (temp value of Larry Lemons)
field i) TST_FR_CASE_OTHERS.FIRM_NME, (temp value of Lemons & Limes)
and spill them out to a single grouped output area for cc: (carbon Copy) such
cc: Linda Z. Zane, Zackery Jones, John Jay Smith, Willa Thomas - Williams &
Williams.
Tommy Smith - Smith & Smith, Larry Lemons - Lemons & Limes
I feel the output field would have to be unbound text box, with can grow and
can shrink enabled yes. Records in the query look like
The resulting query has 3 records in it. Each record in this quiry has
Fields a, b, c, d, e, f, g in it with same names,
but record 1 has Willa Thomas, Williams & Williams
record 2 has Tommy Smith - Smith & Smith
record 3 has: Larry Lemons - Lemons & Limes
What do I have to do to concatenate all names in one output area for form
letter for cc purposes.
Thanks,
key field
01 - Zinda Z.Zane, Zack Zones,