Results 1 to 2 of 2
  1. 02-28-2012, 12:00 PM #1
    jassie
    jassie is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jan 2012
    Posts
    40

    access 2007 update statment

    I would like to know what the sql is in access 2007 to update 5 columns in one table that is joined to a second table.
    Reply With Quote Reply With Quote
  2. 02-28-2012, 05:09 PM #2
    June7's Avatar
    June7
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,625
    Use the Access query designer to help build UPDATE sql. What is the join for - source for the update data? Otherwise, the join might be irrelevant.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Stock Update using VBA in Access 2007
    By thanosgr in forum Access
    Replies: 19
    Last Post: 02-13-2012, 03:21 PM
  2. Unable to update some Sharepoint List records via Access 2007
    By gopherking in forum SharePoint
    Replies: 2
    Last Post: 01-05-2012, 11:52 AM
  3. Like statment
    By brew in forum Programming
    Replies: 2
    Last Post: 12-01-2011, 03:23 AM
  4. Syntax Error on Update Statment
    By TinaCa in forum Programming
    Replies: 2
    Last Post: 09-14-2011, 05:53 PM
  5. Problem Between Access 2003 & Access 2007 Displaying Forms Correctly, Office 2007
    By kfschaefer in forum Forms
    Replies: 2
    Last Post: 06-18-2011, 09:55 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums