Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2014
    Posts
    1

    Unanswered: Linking Data Between Tables Based on Matched Columns

    I have an access database with two tables. Table 1 has items under columns A, B, & C. Table 2 has items under columns D, E, and F. Table 1 Column C has data that matches items in column F of table 2. While column C in table 1 is a unique value for that column column F of table 2 has multiples of the same value. How can I get the database to take the item in column C and find the corresponding value in column F and then copy all of the items in columns D and E in table 2 to columns A and B in table 1?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    use a join, or possibly a where
    Update one table based on another table (MDB) - Access

    update table1 set table1.A=table2.D. table1.B=table2.E
    join table2 on table1.C = table2.F
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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