Welcome to SPN

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

Sign Up Now!

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

Share This Page