I have been looking at a problem the entire week in access, I have still not
been able to find a solution. Hope that you could maybe tell where to look

Concerns the link between Access and Word. I can not transfer a report to
word without losing out on the lay-out (RTF format). I understand that there
is no way out

ok, mail merge I thought. But here I have the problem that I need to merge
multiple tables and that I can just include one in the mailmerge within word.
A query would seem likely but there I have a problem. I have one master table
containing personal information on staff and 8 subtables around the master
table with specifying language, workexp, education for each person. The
number of entries in the subtables varies per person.

In case I use a query to combine all these tables I get # x # x # x # x# (9
times) number of records an extreme number of records for each person.

An example: person A
knows 8 languages
has 3 educational references
10 publications
took 8 courses in his career

This would already result in 1 X 8 X 10 X 8 = 640 records

Do I miss a certain function with queries or how can I work this out? I can
not imagine that it is not possible

Thanks and wishing you a good day

Stefan van den Hark
The Netherlands

There is really no way to do that sort of thing with mailmerge. With only
occasional exceptions, I have found publishing an Access Report to Word as
an RTF works OK. The exceptions have been on very complex reports where I
was really jamming information into the available space and slight
differences between the fonts as displayed by Access and Word did throw
things off. A bit of judicisious re-formatting in Access usually overcame
that problem. Most of the time however, I stick completely with Access, or
if I have to send the report electronically, use Snapshot and point the
recipient to the website from which they can download the Snapshot Viewer.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"svdh" wrote in message
...
I have been looking at a problem the entire week in access, I have still
not
been able to find a solution. Hope that you could maybe tell where to look

Concerns the link between Access and Word. I can not transfer a report to
word without losing out on the lay-out (RTF format). I understand that
there
is no way out

ok, mail merge I thought. But here I have the problem that I need to merge
multiple tables and that I can just include one in the mailmerge within
word.
A query would seem likely but there I have a problem. I have one master
table
containing personal information on staff and 8 subtables around the master
table with specifying language, workexp, education for each person. The
number of entries in the subtables varies per person.

In case I use a query to combine all these tables I get # x # x # x # x#
(9
times) number of records an extreme number of records for each person.

An example: person A
knows 8 languages
has 3 educational references
10 publications
took 8 courses in his career

This would already result in 1 X 8 X 10 X 8 = 640 records

Do I miss a certain function with queries or how can I work this out? I
can
not imagine that it is not possible

Thanks and wishing you a good day

Stefan van den Hark
The Netherlands

Hi Stefan,

Whether you could possibly use mail merge would depend on how the information n
the sub-tables should appear in the report. If it could basically be presented
as a table, then you could link DATABASE fields into the mainmerge document.

For anything "fancier" with Word you'd have to use automation (program VBA) to
generate the document.

I have been looking at a problem the entire week in access, I have still not
been able to find a solution. Hope that you could maybe tell where to look

Concerns the link between Access and Word. I can not transfer a report to
word without losing out on the lay-out (RTF format). I understand that there
is no way out

ok, mail merge I thought. But here I have the problem that I need to merge
multiple tables and that I can just include one in the mailmerge within word.
A query would seem likely but there I have a problem. I have one master table
containing personal information on staff and 8 subtables around the master
table with specifying language, workexp, education for each person. The
number of entries in the subtables varies per person.

In case I use a query to combine all these tables I get # x # x # x # x# (9
times) number of records an extreme number of records for each person.

An example: person A
knows 8 languages
has 3 educational references
10 publications
took 8 courses in his career

This would already result in 1 X 8 X 10 X 8 = 640 records

Do I miss a certain function with queries or how can I work this out? I can
not imagine that it is not possible


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 :-)