Combining Data from Different Records into a Single String Variable "L.A. Lawyer" <kapplaw[ at ]linkline.com> 12/21/2008 7:08:47 AM I want to extract the text of a single field (a mailing address) from a series of records in a query, where the record matches certain criteria, to make a single string variable. This is to insert into Word as a list of addresses. In plain English, I want to pull the address fields from selected records in a query where the record match certain criteria. I have never combined the data from different records to create a single string variable. How is this done?

Re: Combining Data from Different Records into a Single String Variable "Allen Browne" <AllenBrowne[ at ]SeeSig.Invalid> 12/21/2008 8:32:34 AM If one client can have several addresses, and you want to concatenate all of a client's addresses into the one string, see: Concatenate values from related records at: http://allenbrowne.com/func-concat.html -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "L.A. Lawyer" <kapplaw[ at ]linkline.com> wrote in message news:ON3Q6rzYJHA.3844[ at ]TK2MSFTNGP03.phx.gbl... [Quoted Text] > I want to extract the text of a single field (a mailing address) from a > series of records in a query, where the record matches certain criteria, > to make a single string variable. > > This is to insert into Word as a list of addresses. > > In plain English, I want to pull the address fields from selected records > in a query where the record match certain criteria. > > I have never combined the data from different records to create a single > string variable.