MS Access 2016 - SQL for Update Query that updates one column with the value of another column

Hi Experts,

I would like to have an Update query that updates one column with the value of another column.
I'm don't have a clue how to do it.

Here are the details of my Select query:

My database is attached:  LOADS7.mdb.

Here's the Design View:


Here's the SQL:

SELECT TrafficLoadDistributionMetaData.ID, TrafficLoadDistributionMetaData.[ESA per HV], [TrafficLoadDistributionMetaData-ESA per HV].[ESA per HV]
FROM [TrafficLoadDistributionMetaData-ESA per HV] INNER JOIN TrafficLoadDistributionMetaData ON [TrafficLoadDistributionMetaData-ESA per HV].ID = TrafficLoadDistributionMetaData.ID;

Select allOpen in new window

Here are the results of the Select Query:


In summary, looking at the results above, I want the numbers in the right hand column to be copied to the blank column.

Regards,
Leigh