Results 1 to 2 of 2
  1. #1
    taimysho0 is offline Competent Performer
    Windows XP Access 2000
    Join Date
    Nov 2011
    Posts
    286

    Create Query to UPDATE a COLUMN in a Table with another Table??

    Hello i have two tables, a main table and a table i want to update a particular column in my main table with. Lets call this table 2. how do i create a query that updates a column called "last read date" in my main table with that of the Table 2? (same column). The only thing is Table 2 does not have a primary key and must maintain that way, i dont know if that would make a difference though. thanks!

  2. #2
    jzwp11 is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    Other than the "last read date" field, is there any other field that is common between the two tables? Does table 2 have a foreign key field (not a primary key field) that relates back to a record in the main table?

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

Similar Threads

  1. Replies: 1
    Last Post: 12-17-2011, 02:42 PM
  2. Use query or table to update another table
    By fblanchard in forum Queries
    Replies: 3
    Last Post: 10-18-2011, 07:36 PM
  3. Replies: 3
    Last Post: 05-19-2010, 10:08 PM
  4. Query to get column names in a table
    By access in forum Queries
    Replies: 1
    Last Post: 07-06-2009, 05:10 AM
  5. Query to get column names in a table
    By access in forum Forms
    Replies: 1
    Last Post: 07-01-2009, 02:50 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
  •  
Other Forums: Microsoft Office Forums