Update query - where id equals (1 Viewer)

[tezread]

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?

 

[Alansidman]

What issues do you have when you run the update query. Error messages? Help us to help you. Give us some information.

 

[hudson426]

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

 

[tezread]

thank you guys - thats ueful