SQL One to Many Relationships

[thelittleone]

RFI 001 AECOF
RFI 001 ABDRC
RFI 001 GFVDE

After grouping the above example by RFI number and suppressing duplicate values, I am faced with the following layout:

RFI 001 AECOF
ABDRC
GFVDE

Is there a formula that I can create to display the information in the following manner?

RFI 001 AECOF, ABDRC, GFVDE

Thanks,

TheLittleOne

 

[ianoctdec]

Hi thelittleone,
Check out thread # 767-940552.

Dana

 

[kskid]

ianoctdec,

EWhen referencing a thread, just enter it in one complete string. Instead of thread # 767-940552, enter it as Thread767-940552 which provides an immediate link to the post.

Cheere,

-LW