Results 1 to 3 of 3
  1. #1
    Join Date
    May 2015
    Posts
    2

    Answered: Help in creating an update query

    Hello,
    I need to create an update query to replace skus in one table if they match skus from another table. Say I have table "A" i created with 2 fields SKU and AltSKU. I need to create an update query that updates SKUs from table "B" if they match a sku from table "A". If the sku in table "B" matches a sku in table "A", then the sku in table "B" will be replaced by the AltSKU from table "A". I hope i explained that right. Thanks!

  2. Best Answer
    Posted by ranman256

    "In the update query,
    Bring in both tables,
    Grab the A.SKU field, drag and drop on B.SKU
    They will link ,meaning, only if they match the change will happen.
    Then dbl-click B.SKU to put it in the qry grid
    Next under B.SKU, set the update box to A.ALTSKU"


  3. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    496
    Provided Answers: 24
    In the update query,
    Bring in both tables,
    Grab the A.SKU field, drag and drop on B.SKU
    They will link ,meaning, only if they match the change will happen.
    Then dbl-click B.SKU to put it in the qry grid
    Next under B.SKU, set the update box to A.ALTSKU

  4. #3
    Join Date
    May 2015
    Posts
    2

    Thumbs up

    Thanks ranman256! That works great. I appreciate your help .

Posting Permissions

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