Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / March 2005

Tip: Looking for answers? Try searching our database.

Help with a Header/Detail relationship merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Keith-Earl - 30 Mar 2005 15:16 GMT
Hello,

I am running Word 2002 SP3.  I currently print our monthly invoices from a
"flat file" (unnormalized table) in MS Access.  It works great: one invoice
per record.

Now I want to show line items on my invoice.  I think I must somehow add a
sub-document on my existing form to house the new line items.  In that
sub-document I will have to tell the query (or Word) to only select the line
items for that particular invoice.  How do I do that?

I will gladly by a book or upgrade to Word 2003 if that help.

Many Thanks,

Keith
Cindy M  -WordMVP- - 30 Mar 2005 16:30 GMT
Hi Keith-Earl,

You'll find a short discussion on three possible approaches, with links to
instructions and sample files in the mail merge FAQ on my website. Try the
DATABASE field one, first, I think...

> I am running Word 2002 SP3.  I currently print our monthly invoices from a
> "flat file" (unnormalized table) in MS Access.  It works great: one invoice
[quoted text clipped - 4 lines]
> sub-document I will have to tell the query (or Word) to only select the line
> items for that particular invoice.  How do I do that?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)
Keith-Earl - 30 Mar 2005 16:47 GMT
Thank you, Cindy.  I did find this page:

http://homepage.swissonline.ch/cindymeister/MergFram.htm

But cannot find the articles you are referring to.  Please direct me to
those articles.

Thanks,

Keith

> Hi Keith-Earl,
>
[quoted text clipped - 23 lines]
> reply
> in the newsgroup and not by e-mail :-)
Cindy M  -WordMVP- - 31 Mar 2005 18:57 GMT
Hi Keith-Earl,

> http://homepage.swissonline.ch/cindymeister/MergFram.htm 
>  
> But cannot find the articles you are referring to.  Please direct me to
> those articles.

"Multiple items per condition" in the Special Merges section.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.