Combining Data from Different Records into a Single String Variable

[L.A. Lawyer]

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?

 

[Allen Browne]

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