I need help to construct an update query to populate MynewField
with contents from multiple fields and rows where the MapID
is the same.
RowID---MapID-----Extension----- Name------ MynewField
7 318 #222 [#222Tom]
22 318 Tom [#222Tom]