Updating Fields in Tables 1

[avaffa]

How can I replace the values in a field in Table1 with values from a field in Table2? Thanks!

 

[Yarcadian]

Use an Update Query, link the two tables together using your index key or primary key and bring down the field from table1 that you want to replace. Under the Update To point it to the table and field where you want to pull data from. You can go a step further and add criteria such as Is Null, which will only replace blank fields.

David