I have been trying to create an update query that pulls data from a second table to update the first table. The first Table that has data in one field that I want to use to update a different field in the same table. The value to update it with is stored in Second table. In my query I linked the two fields that need to be equal, [table1].[field3] = [table2].[field3]. I would like it to update [table1].[field2] with the value stored in [table2].[field4]. When I run the query it returns the primary key and not the value of field4. I am using Access 2010, is there something I am doing wrong? 
