How Merge to a Conditional List?

D

David Habercom

My Access query lists donor names (DonName) and their associated endowments
(Endwmt.) In most cases, each donor funds one endowment. But in some, the
donor supports multiple endowments. The query is alphabetized on DonName.

The challenge: each page shows one donor and lists all his/her endowments,
in a stacked arrangement. How do I compare the current DonName with the
PREVIOUS DonName and then 1) print another Endwmt field or 2) go to the next
page & DonName?

I am totally lost on this.
 
D

Doug Robbins - Word MVP

Word does not really have the ability to perform a "multiple items per
condition (=key field)" mailmerge.

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

Or take a look at the following Knowledge Base Article

How to Work Around Duplicate Names in Mail Merge Data

http://support.microsoft.com/default.aspx?scid=kb;en-us;302665


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top