Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Merging Query Data from Access to Word.

Discussion in 'Information Technology' started by SAM, Australia, Jul 28, 2006.

  1. SAM, Australia

    SAM, Australia
    Expand Collapse
    Guest

    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:

    x y1 z1
    y2 z2
    y3 z3.

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

    Cheers,

    SAM
     
  2. Loading...

    Similar Threads Forum Date
    India Punjab emerging as major drug producing centre Breaking News Mar 13, 2013
    Under-19 emerging sikh cricketers Sports & Fitness Jan 22, 2010
    Merging in the Word Of Sabad Sikh Sikhi Sikhism Jan 26, 2008
    Sikh News Punjab emerging as new international education hub (New Kerala) Breaking News Sep 17, 2007
    Sikh News Punjab emerging as new international education hub (ANI via Yahoo! India News) Breaking News Sep 17, 2007

  3. OP
    Albert D.Kallal

    Albert D.Kallal
    Expand Collapse
    Guest

    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/cindymeister/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
     
  4. OP
    Sheila D

    Sheila D
    Expand Collapse
    Guest

    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
    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:
    >
    > x y1 z1
    > y2 z2
    > y3 z3.
    >
    > Your help on helping solve this challenge would be greatly appreciated.
    >
    > Cheers,
    >
    > SAM
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page