Update query not working (2003)

Topic

New Reply

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

Reply | Quote

Replies

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).

Reply | Quote