It's me again.  Which means the solutions you offer cannot be coded in VBA,
for I am, the Macrobater! ;)  Kidding aside...

I'm trying to create a document in Word.  The document is a trip report
which contains all deficiency reports pertaining to that site at the end of
the overall trip report.  Much of the front data is boilerplate that will be
edited by the user.  The deficiency reports are all contained in Access in
tables with a one to many relationship.

I've looked at mail merge, but it doesn't appear that I can get relational
tables out of Access and into Word with mail merge.  Creating the report in
Access and outputting in RTF would be fine, except how do I get the document
boilerplate info in front of the table data?

I've looked at the marketplace.  I've tried to work with a few of the
products but if there is a solution in one of them, I don't understand how to
use it to accomplish what I need.

I'm not looking for you guys to necessarily do my work, but point me down
the right path.  I don't want to spend a great deal of time trying to make
mail merge, or reports do something it will never do.  If you had to create
such a report, what path (outside of coding the report) would you take?  Is
there an application that could make all of this easy for a price?

Thanks in advance,
Matt