Concatenate text fields in query

I have the results of a query to send to a mailmerge with Word 2000. The
query produces say 6 to 8 records, where only 1 of the fields is different
from record to record. I can only have one record for my mail merge, so I
would like to concatenate the 6 to 8 records into 1 with the text field that
is different in each record being concatenated into a single text field with
a carriage return/line feed at the end of each record so it comes out in the
mailmerge docment as a column/list of 6 to 8 things. Don't know how well I
have described that, but can anyone help me please?

TIA
dixie


.

Relevant Pages