Right! I'd forgotten the "List()" function. Beverly
On 8/26/08 1:47 PM, "Tom Elliott" <[EMAIL PROTECTED]> wrote in whole or in part: > Barbara > > If you're using v8.5 or 9, List ( <repeating field> ) will return a > carriage return delimited list of al the repetitons. You can then > replace the returns with whatever character you prefer with Substitute > (). So you new field calc could be something like: > > Substitute ( List ( <repeating field > ; ΒΆ ; "," ) ) > > cheers > > Tom > > > On 26 Aug 2008, at 6:15, BARBARA PASSMAN wrote: > >> thank you >> I am exporting from Mr. Jones' record,not from the related rcords. >> Your last point; making the repeated field one calculation IS >> something I thought about but don't know now to do. >> IF you or someone can point me the right way , that will solve most >> of the problem >> >> The other problem , my first, is that although I am trying to export >> Mr. Jones' record (its actually a sports team record, listing the >> Team, Mr Jones and his assitant. >> This is the core data. Data is a direct import from an Excel >> spreadsheet. >> The portal, related data are the training credentials for Mr, Jones >> and his assistant. >> That exports! but only one the first item. So I have to try the >> calculated field...and that sounds like it could be complicated but >> worth learning how to do. >> >> Thank you so much >> Barbara P
