Concatenating strings

[ColinDow]

I have a recordset which takes the form____Product__XX__XYZ__YZA__BBB__AAA__ABC__etc____I^s like to produce a report which groups to a particular criteria (say product category - not shown) so that on the footer I get a concatenated string such as____1)XX,XYZ__2)YZA,BBB,AAA__3)ABC etc.____I dont know how many products will exist when the report runs.

[rickwjohnson]

I asked this same question several years ago when R&R was with WallData. The tech then sent me R&R Tech Bulletin #6 - Printing Related Records on one line in R&R for Windows. Perhaps Kathleen has access to it and can send it to you. If not, email me at rickwjohnson@hotmail.com and I will send you a copy. (I do not have a fax, so snail mail is the delivery method.) It is 4 pages long with an example. ____Rick Johnson

[ColinDow]

Thank you Rick.__Kathleen I had a quick look at the tech bulletins but didnt see anything that looked like the document in question.____Do you know if it is still available anywhere.

[kfleming]

It is http://www.livewarepub.com/ftp/TechDocs/Printing_Related_Records.pdf____Kathleen__R&R Support

[ColinDow]

many thanks