Results 1 to 2 of 2
  1. 08-28-2014, 09:43 AM #1
    tep186
    tep186 is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    May 2014
    Posts
    4

    Update data from one table to another table

    I have to two tables and I was add data to second table only if the field matches. Lets I have two fields site and recid on both and I want to update site on the second table only if recid from the first table matches the recid from the second table.
    Reply With Quote Reply With Quote
  2. 08-28-2014, 10:04 AM #2
    JoeM
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    See here: http://www.techonthenet.com/access/q...date2_2007.php
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Update a Table when Changing Data in Another Table
    By mone76 in forum Access
    Replies: 1
    Last Post: 12-02-2013, 09:11 AM
  2. How to use data in one table to update a field in another table.
    By mdnikki in forum Queries
    Replies: 7
    Last Post: 03-21-2013, 09:43 AM
  3. how to update a filed of table A by entirng data on Table B
    By armankln in forum Access
    Replies: 3
    Last Post: 09-16-2012, 10:20 AM
  4. How to update data in a linked table from local table?
    By ridwan in forum Access
    Replies: 0
    Last Post: 05-21-2012, 11:54 PM
  5. Help with Update query: updating one table based on data selected from another table?
    By mjblay in forum Queries
    Replies: 6
    Last Post: 05-10-2012, 08:20 PM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums