Concatenating fields

[thecricketer]

This is probably simple, but I don't have my thinking cap on today.<br>
Imagine my table looks like this<br>
<br>
sample det<br>
1234 abc<br>
1234 fgh<br>
1234 xyz<br>
1235 fgh<br>
1235 ijk<br>
<br>
What I need to do is, say in a group footer show<br>
sample dets<br>
1234 abc,fgh,xyz<br>
1235 fgh,ijk<br>
<br>
for all dets, anyone any ideas?<br>
<br>
John

 

[MalcolmW]

I used this in a similar situation<br>
StringVar ConcatText ;<br>
If ConcatText = &quot;&quot; then<br>
ConcatText:= {Customer.Customer Name}<br>
Else If ({Customer.Customer Name} in ConcatText) then<br>
&quot;&quot;<br>
Else<br>
ConcatText := ConcatText + &quot;, &quot; + {Customer.Customer Name}<br>
You might want to add some trim functions, depending on your data. This ignores duplicates also, which may or may not be desirable. And the result is limited to 254 characters in length. I have a more complex solution to chain multiple formulas to get around this, but I'm not proud of it. <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>