Vertical - Group & Concatenate?

[jw5107]

Is there a way to concatenate vertically??

Meaning - instead of having the data showing in field like:
abc, def, ghi, jkl
Have it show like this:
abc
def
ghi
jkl

I have been working with:
[Fleet] & Chr(13) & Chr(10) & [Movement-Type]
Works, but not how I need for it too...

I need to be able to group on IID, and then show a "vertical concatenation" for each child record of IID.

Any suggestions?? Or examples??
Thanks in advance!!
jw

 

[PHV]

Any chance you could post the table(s) layout, some input samples and expected result ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jw5107]

PHV,

Thanks for the response!!

TableName: ShpFrmLocs
Fields(3ea): IID - text
Fleet - text
ShpFrm - text
Right now the table shows the data like:
IID Fleet ShpFrm
3300000061619 DC-8 MEL- From SDF to LCK(1)
3300000061619 DC-8 AOG- From SDF to PBI(1)
3300000061619 757 MEL- From SDF to AMC(1)
3300000061619 A300 CRI- From SDF to JFK(1)
3300000061619 A300 ALT- From SDF to TEC(1)

Would like for it to show like this:
IID Movement
3300000061619 DC-8
MEL- From SDF to LCK(1)
AOG- From SDF to PBI(1)
3300000061619 757
MEL- From SDF to AMC(1)
3300000061619 A300
CRI- From SDF to JFK(1)
ALT- From SDF to TEC(1)
Sure hope this makes sense - let alone be possible!!
Thanks for the help!!
jw

 

[PHV]

This is much a report issue than a SQL one.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jw5107]

PHV,

Ok - thanks!
I will work with a subreport then......
Thanks!!
jw