Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Jun 2002
    Location
    Michigan City, Indiana, USA
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Update query not working (2003)

    I have an update query with the following SQL:

    UPDATE tblCurrentCourses INNER JOIN [Course List] ON tblCurrentCourses.CReferenceNum = [Course List].Course SET tblCurrentCourses.CCourseName = [Course List]![CourseTitle];

    When I go to view what will change in the CCourseName column, nothing has changed. It has the same values as before.

    Thanks in advance,

    Jodi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Update query not working (2003)

    When you create an update query and switch to datasheet view, it will display the records that will be affected by the update, but it will display the current situation, not the situation after the update. To execute the update, switch back to design view, and select Query | Run or click the Run button on the toolbar (the button with the exclamation mark).

Posting Permissions

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