Welcome to SPN

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

Sign Up Now!

HELP ME!!!!

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

Tags:
  1. Lorii02

    Lorii02
    Expand Collapse
    Guest

    I have several tables with different categories in each one that need to be
    combined into one master table. how do i do this without just retyping the
    information over in a new table? there are over 2,000 entries all together i
    don't want to do this manually.
     
  2. Loading...


  3. Sprinks

    Sprinks
    Expand Collapse
    Guest

    Lori,

    It certainly can be simple to do what you intend, however it's impossible to
    advise you how without knowing the structures of the tables. Please post
    their fields and fieldtypes and we can help.

    Sprinks

    "Lorii02" wrote:

    > I have several tables with different categories in each one that need to be
    > combined into one master table. how do i do this without just retyping the
    > information over in a new table? there are over 2,000 entries all together i
    > don't want to do this manually.
     
  4. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Tue, 25 Jul 2006 12:09:02 -0700, Lorii02
    <Lorii02@discussions.microsoft.com> wrote:

    >I have several tables with different categories in each one that need to be
    >combined into one master table. how do i do this without just retyping the
    >information over in a new table? there are over 2,000 entries all together i
    >don't want to do this manually.


    Please don't yell, Lori. Most people who post here want help; we
    realize that, it's why we spend our time volunteering. A simple "How
    do I combine tables?" as a subject line will get you answers just as
    fast.

    To answer - it sounds like one or more Append queries would be useful.
    As Sprinks suggests, we'd better be able to help you if we knew what
    you are working with; *you* can see your computer - we cannot.

    John W. Vinson[MVP]
     

Share This Page