Update a field (1 Viewer)

[AnnPhil]

Is it possible to use an update query to update existing blank fields with data from another table? If not how would you do this?
I have a table that has 1000 records. I need to update one field in about 900 records. The value for the field is stored in another table, how can i get those values into the table.

 

[Pat Hartman]

Create a new query. Add both tables to the QBE grid. Draw a join line between the linking field. Select the field that you want to update. Change the query type to Update. In the Update To cell, type the fully qualified name of the source column from the other table.

[OtherTable].[SomeField]

Be sure to use the square brackets.

 

[AnnPhil]

Thanks Pat, that worked great!