1.create new field, as desired in destination table 2.create Update query reference both source and destination tables/queries 3.double-click on new field in destination table to create new-field reference 4.right-click on Update To: row of new-field reference, click on Build 5.locate source field in source table/query 6.double-click and click OK 7.click Run