Welcome to SPN

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

Sign Up Now!

combine tables into a "master"

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

  1. lay

    lay
    Expand Collapse
    Guest

    I will have weekly tables added to the data base, and i'd like to know how to
    combine these tables into a "master" (same field headings, with the latest
    table's data added to the end of the master table as new records) so i can
    create graphs in excel by using the pivot tables. This process needs to be as
    easy as possible. I remember doing it once with literally just a click of a
    button, but frustratingly, i've forgotten how.

    Again, this will be an ongoing process, and i would preferably not have to
    keep modifying queries/codes

    Thanks!
     
  2. Loading...

    Similar Threads Forum Date
    SciTech New Quantum Dot Technique Combines Best of Optical and Electron Microscopy Breaking News Jun 17, 2013
    SAD-Sant Samaj Combine Sweeps SGPC Elections Sikh Sikhi Sikhism Sep 19, 2011
    SciTech 3,000 images combine for Milky Way portrait Breaking News Nov 2, 2009
    Sikh News SAD-BJP combine sweeps civic polls in Punjab (Outlook India) Breaking News Aug 8, 2007
    India 11 Constables Get Pregnant at Training School Breaking News Apr 26, 2011

  3. Rick B

    Rick B
    Expand Collapse
    Guest

    answered in your duplicate post at 12:38.

    --
    Rick B



    "lay" <lay@discussions.microsoft.com> wrote in message
    news:7BC23FD1-BF13-4470-B9D2-79EEFB4346EB@microsoft.com...
    >I will have weekly tables added to the data base, and i'd like to know how
    >to
    > combine these tables into a "master" (same field headings, with the latest
    > table's data added to the end of the master table as new records) so i can
    > create graphs in excel by using the pivot tables. This process needs to be
    > as
    > easy as possible. I remember doing it once with literally just a click of
    > a
    > button, but frustratingly, i've forgotten how.
    >
    > Again, this will be an ongoing process, and i would preferably not have to
    > keep modifying queries/codes
    >
    > Thanks!
     

Share This Page