Update Query

Hi James

Thank you for your question

You need to create an update query to accomplish this.

Create a basic select query in the normal way that includes the field that you need to update. On the design ribbon select update query from the query type group. In the design table enter Adstream in the update to row and adstreamtv in the criteria row.


If the table you are updating is also linked to other tables and you have enabled referential integrity, you will also need to allow cascade updates. To do this open the relationships window, double click on the link and select the appropriate check box

I would also strongly advise that you back up the database before running this procedure

Regards

Stephen