Welcome to SPN

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

Sign Up Now!

combine tables

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

Tags:
  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. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    lay wrote:
    > 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)


    Note: data in tables do NOT have an order. The idea of adding them to
    the "end" of the mater table is not meaningful. Do not rely on the data in
    a table being in or staying in any sort of order. If you need an order, YOU
    have to provide it by using or providing and then using a field that has
    data that can be sorted in the order you need.

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


    There are many possible ways of doing this. Since we don't know exactly
    how you will be receiving the data and exactly what formation it will be in,
    it would be very difficult to suggest the best solution.

    For example will the information be made available on a LAN, or e-mailed
    etc. Will the data be in the form of an Access file or a comma delineated
    format or what?



    --
    Joseph Meehan

    Dia duit
     
  4. Rick B

    Rick B
    Expand Collapse
    Guest

    I guess the question would be why you are creating a separate table every
    week? You only need the master table. In your queries, reports, and forms
    that should only show the current week's details, you'd simply include a
    filter to pull out the appropriate records.

    Any time you have to constantly create tables (that are identical to others)
    or move records from one table to another, you probably have a design flaw.

    --
    Rick B



    "lay" <lay@discussions.microsoft.com> wrote in message
    news:072FB21A-744E-4E3C-B726-98A06A4619C9@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!
     
  5. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Rick B wrote:
    > I guess the question would be why you are creating a separate table
    > every week? You only need the master table. In your queries,
    > reports, and forms that should only show the current week's details,
    > you'd simply include a filter to pull out the appropriate records.
    >
    > Any time you have to constantly create tables (that are identical to
    > others) or move records from one table to another, you probably have
    > a design flaw.


    That's a good point. I was thinking that he was getting the data from
    another area, but he really does not say that. Let me add my opinion that
    if the data can be added directly to this database that is the way to go.
    Don't use two systems to do what one will do far better.

    --
    Joseph Meehan

    Dia duit
     

Share This Page