Update query - where id equals

tezread

Registered User.
Local time
Today, 04:24
Joined
Jan 26, 2010
Messages
330
I have a table called tblEpisode with a unique if EpisodeID.
I have been given an Excel spreadsheet with a list of EpisodeID and follow up comments against each.
I have added a new field to tblEpisde called FollowUpComments.I am trying to run query which updates each episode and adds the comments?
 
What issues do you have when you run the update query. Error messages? Help us to help you. Give us some information.
 
Tezread

Example attached.

In essence, you need to create a query that updates the relevant records.

In the example, go to qryEpisodeCommentUpdate and run it, accept the warning and then look at the tblEpisode. You will see the comments have been updated.

The query effectively finds matching show id's from tblEpisode and tblEpisodeComments. Then updates the FollowUPComments with the data stored in the Comments field of the tblEpisodeComments table.

Any problems, please let me know.

Jonathan
 

Attachments

Users who are viewing this thread

Back
Top Bottom