Getting Details from a repeating field

[simoncpage]

I have a field which is related to another file with field that contain serials separated by "

[LaRetta]

I'm unsure from your description exactly what you want. Are you saying you need to extend the Company to each serial which is separated by carriage returns (and not repeating fields)? Try:

Company & " " & Substitute(Serial, "