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

  • Getting first 2 numbers of the current year
    ... How do I parse out the 20 from the current year. ... TIA ... Prev by Date: ...
    (comp.databases.ms-access)
  • Re: Combobox help
    ... > I want the following THREE options to be available from the combobox [and ... > TIA ... > Sue Compelling ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Does using index.php affect search engine rankings?
    ... Apologies if this is the wrong group ... TIA ... Dynamo ... Prev by Date: ...
    (comp.lang.php)
  • Re: Stop a service programatically
    ... > Any thoughts/help? ... > TIA - Jeff. ... Prev by Date: ...
    (microsoft.public.dotnet.general)
  • Search Problem
    ... I just need a way to line by line search the entire file, fetching that ... making some modifications and moving further. ... TIA ... Prev by Date: ...
    (comp.unix.shell)