Skip to Content
author's profile photo Former Member
Former Member

Returning results from same column into one field

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 23, 2008 at 08:10 AM

    By grouping the section, the output can be displayed.

    For Ex:

    Column1 Column2

    Fruit Apple

    Mango

    Banana

    Flower Rose

    Jasmine

    Lily

    Thanks.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 23, 2008 at 07:11 AM

    HI,

    PLease try this sample

    NumberVar Counter := 1;

    StringVar Accum;

    do

    ( Accum := Accum + "Field_xxx";

    Counter := Counter + 1)

    while Counter < 100;

    Accum

    Regards,

    Clint

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.