Results 1 to 3 of 3
  1. #1
    xmetisx is offline Novice
    Windows 7 Access 2007
    Join Date
    Apr 2010
    Posts
    2

    Access insert into query...

    Hello,
    I have two tables that i showed below called LINK and AREA.

    LINK
    ARS_ID KLS_ID
    1 233
    2 433
    3 234


    AREA

    ARS_ID KLS_ID
    1
    2


    3


    I would like to copy KLS_ID row from LINK table to KLS_ID row from AREA table. While i'm doing this, i want to equal ARS_ID row from LINK table to ARS_ID row from AREA table...

  2. #2
    ConneXionLost's Avatar
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291
    Hi,

    Code:
    UPDATE LINK INNER JOIN AREA ON LINK.ARS_ID = AREA.ARS_ID SET AREA.KLS_ID = [LINK].[KLS_ID];
    Cheers,

  3. #3
    xmetisx is offline Novice
    Windows 7 Access 2007
    Join Date
    Apr 2010
    Posts
    2
    Thank u so much...

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

Similar Threads

  1. SQL Insert into
    By jamin14 in forum Programming
    Replies: 15
    Last Post: 04-01-2010, 12:35 AM
  2. Replies: 0
    Last Post: 02-24-2010, 12:56 AM
  3. Replies: 5
    Last Post: 01-14-2010, 03:37 PM
  4. help with insert
    By jamie in forum Access
    Replies: 1
    Last Post: 11-16-2009, 06:02 AM
  5. Insert Query output into a table
    By ammu_sridhar in forum Programming
    Replies: 1
    Last Post: 06-12-2009, 01:09 AM

Tags for this Thread

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