I have a file which has labels in repeating field called r_labels.  This was put in by a programmer years ago and it makes a menu header.  I want a simple list of those values but I do not know how to turn a repeating field into a calculation which lists them with a carriage return between each repeat.

 

I can not change the existing setup but I can add a calculation and that is what I want, a text calculation as a multiline.  This is only for a display because I want to modify it a bit further.  Is it possible?  Ideas would be great, I searched and found similar but I am not smart enough at this to figure them out.

GetRepetition(r_labels; 1) & "¶" & GetRepetition(r_labels; 2) & "¶" & GetRepetition(r_labels; 3) & "¶" & ... GetRepetition(r_labels; n) 

Or you might try:  List ( r_labels )

 

... but if there is an empty repetition, it will move the values up and close the hole.  A custom function could also handle it ... not sure how much trouble you want to go to to achieve your results.  You can also use a relationship although you indicated you couldn't make other design changes.

Edited June 17, 201312 yr by LaRetta

LaRetta that did the job easily, thank you very much!  I appreciate the response, Doug, and I am sure I'll need your method again at some time.

 

This forum is the bomb.