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