Returning results from same column into one field

[Former Member]

Hi all,

I am relatively new here and would like some help (please). I will try to format the question logically.

I have a table with these Columns: RoKey (UI), MeKey (This links back to the member table), RoleType (Type of role the member has, a member may have more than 1 role).

Data can typically be like the following:

RoKey MeKey RoleType

1 Me001 Rep

2 Me001 UBS

3 Me001 OHS

4 Me002 <Null>

Etc...

I would like to return in a report

Member:

Me001 Role: REP,UBS,OHS

Me002 Role:

This would be two field in an overall report.

Eseentially how do i pull out information in the same field and return it to 1 formula filed.

All help is appreciated

Thanks

Roger

[Former Member · Accepted solution]

By grouping the section, the output can be displayed.

For Ex:

Column1 Column2

Fruit Apple

Mango

Banana

Flower Rose

Jasmine

Lily

Thanks.

[Former Member · Accepted solution]

Hi,

OK, please closed the thread, thank you very much,

Regards,

Clint

[Former Member]

HI,

PLease try this sample

NumberVar Counter := 1;

StringVar Accum;

do

( Accum := Accum + "Field_xxx";

Counter := Counter + 1)

while Counter < 100;

Accum

Regards,

Clint