How do I merge fields for the same record to one document?

[Debbie]

I have only run into this when doing a merge from Access.
It just depends on how your query it set up and what the
ascending grouping is on. In Access merging to a Word
Document, you can only run this type of query on one
item.

Ascending group is usually on primary key like a
customerID. You would not be able to group on anything
else. Since you are only running letters per customer,
this should work for you.

Since there is a limit to how you can merge in Word, I
create letters in Access like a report and just run them
from there. You can group on several different items in
Access.

If you are working on a different database, I'm not sure
how you would run it.

Good Luck.

-----Original Message-----
Here is what I am trying to do:

I have records that I am merging in to a letter which lists all available
loans and their payments. Some people have only 1 loan to list, others have
multiple loans. In my letter I am trying to list each loan individually and
make enough space for the maximum number of loans 1 person would have (6).
What is happening, when I merge the document with the database is that the
letter shows the same loan number and payment amount 6 different times--no
matter how many loans that person has.

I know there is a step I am missing to bring the specific loans for each
individual to the appropriate letter. I can't figure out what to do to make
it work.

The current layout is below. How do I tell the second, third, etc. LOAN to
go to the next loan within the same record?
«LOAN_» «CERTNUM» «LOAN_TYPE» «ACCTTYPE»

Monthly Payment «LOANPMTAMT_»

«LOAN_» «CERTNUM» «LOAN_TYPE» «ACCTTYPE»

Monthly Payment «LOANPMTAMT_»

«LOAN_» «CERTNUM» «LOAN_TYPE» «ACCTTYPE»

Monthly Payment «LOANPMTAMT_»

«LOAN_» «CERTNUM» «LOAN_TYPE» «ACCTTYPE»

Monthly Payment «LOANPMTAMT_»

«LOAN_» «CERTNUM» «LOAN_TYPE» «ACCTTYPE»

Monthly Payment «LOANPMTAMT_»

«LOAN_» «CERTNUM» «LOAN_TYPE» «ACCTTYPE»

Monthly Payment «LOANPMTAMT_»