How do you reverse data once you have created a table?

[ICHDhealth]

I am new to access and I have a table that list first and last name as part
of the field. After entering over a thousand of records, I noticed that the
first and last name was not entered the way I formatted the database and now
I have thousands of records showing the last name in the first name field and
vice versa. Please help if you can.

Thank you,

 

[Dennis]

Create a temporary text field in your table. Open your table and click on the
Surname column header. Click copy and then click on your temporary field
column header and then click paste. Repeat for copy and pasting the Firstname
into the Surname and then the temporary into the Firstname. Remove the
temporary field from the design of your table.