Merging Query Data from Access to Word.

#1 (**permalink**) 28-Jul-2006, 08:29 AM

Hi,

I would like some help regarding merging query results into a word document.

For example,

currently my query results in (there is nothing wrong with my query result)

x y1 z1
x y2 z2
x y3 z3
x y4 z4

My table in access has the three feilds x, y and z, plus ID which is my
Primary key.

However when i merge the above query into a word document, all i get is

x y1 z1

I can not merge in data which is not on the first line of the results table.
What i would like is to be able to merge in data so the result is:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12530-merging-query-data-from-access-word.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12530

x y1 z1
y2 z2
y3 z3.

Your help on helping solve this challenge would be greatly appreciated.

Cheers,

SAM

#2 (**permalink**) 28-Jul-2006, 08:29 AM

the built in word merge will only merge ONE RECORD per each word document.

This is *usually* what most people want.

It seems that you want 'MANY' records to be merged in to ONE document.

The above process unfortunately is difficult....

There are some examples of how to do this here:

http://homepage.swissonline.ch/cindy...r/MergFram.htm

look on the left side for speical merges. The one you want is

Multiple items per condition

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
http://www.members.shaw.ca/AlbertKallal
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12530
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12530

#3 (**permalink**) 28-Jul-2006, 08:29 AM

If you only want the data from the Access database you could try the
Directory option in Word when you set up the mail merge - this outputs all
records as a list however any text you add will be output for each record
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12530
found

Sheila
www.c-i-m-s.com

"SAM, Australia" wrote:

>
> Hi,
>
> I would like some help regarding merging query results into a word document.
>
> For example,
>
> currently my query results in (there is nothing wrong with my query result)
>
> x y1 z1
> x y2 z2
> x y3 z3
> x y4 z4
>
> My table in access has the three feilds x, y and z, plus ID which is my
> Primary key.
>
> However when i merge the above query into a word document, all i get is
>
> x y1 z1
>
> I can not merge in data which is not on the first line of the results table.
> What i would like is to be able to merge in data so the result is:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12530
>
> x y1 z1
> y2 z2
> y3 z3.
>
> Your help on helping solve this challenge would be greatly appreciated.
>
> Cheers,
>
> SAM