Question: how to copy data from one field to another in access?
Answer: Open the database containing the fields you want to copy.
Expand "Tables" or "Queries" in the Database window.
Double-click the table you want to open. ... 
Right-click on the row selector (on the left of the row) to select the entire row within a table.
Select "Copy" from the pop-up list.
Scroll down to the last row.