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.