Trying to concantinate or just add 1 less comma than entries in re

[Guest]

=([Raceway_Num]+", ") if i put this in i get this result. I seem to be going
about this all wrong. What i really want is a list seperated by a comma and
a space that wraps a given area that I am allowing to grow on the report.
Right now I am using a sub report and the colums and rows but as the lengths
vary so much this is wastefull. I would like to turn the following list into.

C-C-17P11-3, C-C-17P11-4, C-P-17XUPSA, C-C-DMR069-TC-2,
C-C-17P11-6, C-P-17XUPSB, C-C-17P21-8, C-P-17P21-7,
C-P-DMR069, C-P-DMR069,

This.
C-C-17P11-3, C-C-17P11-4, C-P-17XUPSA, C-C-DMR069-TC-2, C-C-17P11-6,
C-P-17XUPSB, C-C-17P21-8, C-P-17P21-7, C-P-DMR069, C-P-DMR069

Compact wraped and no comma at the end.
I have looked at the concant2k file as suggested previously but am still
having problems. Any help is appreciated.

 

[Douglas J. Steele]

Since you're always adding ", " at the end, all you have to do is remove the
last 2 characters:

Left(MyString, Len(MyString) - 2)