Results 1 to 5 of 5
  1. #1
    emma is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2012
    Posts
    2

    Question Sql update

    Hi,


    I need some help with the update function in the SQL mode.

    SELECT Film.Nummer, Film.Titel, Film.Köpt, Film.Genre, Producent.Regissör
    FROM Producent INNER JOIN Film ON Producent.[Nummer] = Film.[Nummer]


    In my database I have a movie called Underworld (Film.Titel = movie.titel) and I want to change Film.köpt(=Movie.Bought) from 2008 to 2009.

    Any ideas on how I should do it? Totally clueless on this one

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Review http://www.w3schools.com/SQl/sql_update.asp

    Access Help also has guidelines.

    Use the query designer to help build the UPDATE. Query in design view, click the UPDATE button on the Design tab.
    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.

  3. #3
    emma is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2012
    Posts
    2
    Thank U

    Just another stupid Q:
    What is the table name in
    SELECT Film.Nummer, Film.Titel, Film.Köpt, Film.Genre, Producent.Regissör
    FROM Producent INNER JOIN Film ON Producent.[Nummer] = Film.[Nummer]
    ?

    I'm such a probie at this...

  4. #4
    recyan's Avatar
    recyan is offline Expert
    Windows 2K Access 2000
    Join Date
    Dec 2011
    Posts
    662
    Don't know if I have misunderstood your question :
    Table / Query names :
    1) Producent
    2) Film

    Thanks

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    The query has two table and/or queries that are joined.

    Film
    Producent

    Perhaps we don't understand your question because how would you not know the names of tables and queries in your project?
    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.

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

Similar Threads

  1. Replies: 4
    Last Post: 11-10-2011, 03:41 PM
  2. Replies: 1
    Last Post: 08-19-2011, 12:16 PM
  3. Update 2 tables with one Update Query
    By Douglasrac in forum Queries
    Replies: 4
    Last Post: 04-14-2011, 08:33 AM
  4. Replies: 1
    Last Post: 01-22-2011, 12:23 PM
  5. Update field in table after update on a subform
    By jpkeller55 in forum Queries
    Replies: 3
    Last Post: 09-30-2010, 08:02 PM

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