mail merge with access query

[TheDon]

I am trying to word merge a query that has multiple tables. I want to merge
each record by the parent index and have all the child fields for that record
on each page. My current result is one primary records for every child
record in the datasource, which is not my intended result. Is this more of
an Access question?

thanks,

Don

 

[Peter Jamieson]

You have various options including:
a. create the report using the Access reporter
b. specify the parent table as the mail merge data source, and use a
DATABASE field to insert a table of child rows for each parent record.
However, that probably isn't a particularly good way to go.
c. use VbA and Word's MailMerge events to do much the same as (b), but
programmatcally inserting the list of records, which you would need to
fetch using a separate ADO connection
d. construct a query that "flattens" the data, then use the approach
documented by macropod at e.g.


http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=731107


If you are trying to list several different types of child records for
each parent, you probably nee dto aim for (a) or (c).

Peter Jamieson

http://tips.pjmsn.me.uk

 

[TheDon]

Peter,

I have started w/ option C using the "category" and IF statement setup, but
it may be a too complicated. I have several child entries for the one merge.
Would it be easier to stick with a report? Any special setup their, other
than working off a query fo the data?

thanks for the help... I'm learning a ton this week.

Don

 

[Doug Robbins - Word MVP]

Definitely easier to do with a report in Access.

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

 

[TheDon]

I think an Access report might be the best answer: I know this is a Word
topic folder, so I won’t ask anymore questions in this topic, but here is
what I am trying to do:

We send a letter from camp to parents the first day of camp that has some
common information for all campers and then some specific details for their
son.

1. Details include: campers activity schedule (form activity table); a brief
bio about the counselor and the counselor picture (from two other tables
based on the selection of the counselor); as well as the usual address
(parent table); camper name and cabin (camper table);
2. Is there anyway to drop a field in the middle of the common text like you
would a mail merge, like camper name, counselor name, etc.???
3. Any other layout issues in the report?

Thanks,

Don

 

[Doug Robbins - Word MVP]

Yes, you would using grouping on your report, with all of the information
that it to appear just one time in the Group Header/Footer and the
individual's multiple detail items in the Detail section

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