Merging results to single text box

[jamesdpmullan]

Hi

I have a large database which runs various reports however i am struggling with the last bit to get this report working.

Under each "Works Order" is a set of scrap which is associated with this batch. Instead of rows of data i would like to add all the "reason for scrap" to a single text box for each works order:

Ie. WO: 259953 | Scrap: Sub contract inner open; Untraceable short; short to plane etc etc.

I have attached an image in its current format.

Any help appreciated.

 

[plog]

To have the data at that level, you would need to store it at that level. It should be stored in your batch/work order table.