B
Brian
I need to concatenate the contents of a specific field from multiple records
into a single, multi-line result. I know how to use Chr(13) & Chr(10) to get
the carriage returns & linefeeds. The problem is figuring out how to
concatenate the contents of a specific field from multiple records into a
single field in the output of the query.
Real-world explanation: each customer can have multiple notes of different
types, and we need to track them separately. However, in one context, I want
to print a report by customer that shows all notes of a specific type as a
single multi-line memo, with each note on a separate line.
I know I could do all of this opening a recordset & looping through the
notes, building a string as I go, and then saving it to a field in a
temporary table that I use as the source of the report, but isn't there some
easier way? I think I've got tunnel vision on this one.
into a single, multi-line result. I know how to use Chr(13) & Chr(10) to get
the carriage returns & linefeeds. The problem is figuring out how to
concatenate the contents of a specific field from multiple records into a
single field in the output of the query.
Real-world explanation: each customer can have multiple notes of different
types, and we need to track them separately. However, in one context, I want
to print a report by customer that shows all notes of a specific type as a
single multi-line memo, with each note on a separate line.
I know I could do all of this opening a recordset & looping through the
notes, building a string as I go, and then saving it to a field in a
temporary table that I use as the source of the report, but isn't there some
easier way? I think I've got tunnel vision on this one.