Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    29

    Unanswered: Merge Tables and Remove Duplicates

    I have two tables:

    - AllNames
    - NamesWithID

    AllNames is a list of all names, where as NamesWithID had a column of data that associates the name with the ID.

    What I would like to do is combine these two tables - give AllNames a 2nd column, and if the tag is available, fill that in. Otherwise, it will be blank.

    I'm stumped...

  2. #2
    Join Date
    Feb 2004
    Posts
    29
    Nevermind, I got it.

    I created a query that joined the two tables via the Names column, and changed the join properties to "Include ALL records from 'Names' and only those records from 'ID' where the joined fields are equal".

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •