Joining Tables

Discussion in 'Access Conversion' started by Chris Harmon, Jan 10, 2012.

  1. Chris Harmon

    Chris Harmon Guest

    I am new to access and I can catch on to things pretty quickly so here
    is a simple idea of what I want to do but on a muchhhhh larger scale.
    I need to take data from table2(new and updated) and combine it with
    table1(old database).

    Table 1
    ID Label
    1 a
    2 b
    3
    4 d
    6 f

    Table 2
    ID Label
    1 a
    2 b
    3 c
    4 d
    5 e

    Final Product (table 1 updated)

    Table 1
    ID Label
    1 a
    2 b
    3 c
    4 d
    5 e
    6 f


    In other words Table 1 will be my database. Table 2 will be in the
    same format. Sometimes with the same id's with updated(not
    duplicated) labels sometimes with new ID's that need to be added.


    **If an ID exist in both tables update the information in table1 with
    table2 data for that ID.
    **If table 2 contains a new ID, Add it to the table1 database
     
    Chris Harmon, Jan 10, 2012
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.