Query For Mail Merge

[Bell]

Hi,
I've created a query to be used for a Word mail merge. Today each ow in the
resulting query contain; a customer name, a customer agreement number and
about 40 other fields. Since most customers have more than one agreement my
query typpically looks like this;

Customer Agreement
A A1
A A2
B B1
C C1
C C2
C C3

This implies that when I carry out my mail merge with attachements from Word
a separate document is created for each agreement number i.e. 6 reports as
per the example above. My question however how I can make Word create only
one report per customer i.e. 3 reports as per the example above. Reading the
forum I have understood that Word lacks this ability and that the most
convinient way would be to use Access for this but my question is how?

Regards, Johan

 

[Sheila D]

You would need to write your report in Access. You can base it on the same
query but get it to group on customer. If you don;t use the report writer
normally try the Create report using Wizard and follow the steps.

HTH - Sheila

 

[Duane Hookom]

You should be able to do this in Word Merge with NextRecord or something
similar. You can also use Access to concatenate the Agreement values for
merging. There is a generic concatenate function and sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane