Results 1 to 3 of 3
  1. #1
    amanthethi is offline Novice
    Windows 10 Office 365
    Join Date
    Feb 2021
    Posts
    7

    To Update Two rows in a table from other table on two conditions Query

    Hi there,

    I have two tables Table1 and Table2, I want to update those x and y in Table 1 with a and b in Table 2, where ID of Table 1 is matching with ID of Table 2 and z in Table 1 is Null.
    Please tell me how to write the expression for this ?.


    ID x y z
    1 5543 534 543
    2 7546 34 54
    3 7645 34 245
    4 234 234
    5 65 456
    6 234 5653


    7 465 653




    ID a b c
    1 7 7
    2 7 7
    3 7 7
    4 7 7
    5 7 7
    6 7 7
    7 7 7



    Thanks and Regards.

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    8,778
    already posted and answered here in this forum
    https://www.accessforums.net/showthread.php?t=83028

    If I was a moderator, I'd tell you not to post the same issue in different places, but I'm not so I won't.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    Iím telling everyone it's good to eat dried grapes. Itís all about raisin awareness.

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,839
    write an UPDATE query to update the needed rows using criteria.
    (query designer)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Use Form to Update Existing Table Rows
    By pkjividen in forum Database Design
    Replies: 4
    Last Post: 02-22-2018, 02:44 PM
  2. Replies: 5
    Last Post: 08-25-2015, 08:39 AM
  3. Replies: 1
    Last Post: 10-29-2012, 08:15 AM
  4. Replies: 11
    Last Post: 08-10-2012, 10:25 PM
  5. Replies: 2
    Last Post: 05-30-2012, 10:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums