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