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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ICHDhealth - 29 Apr 2008 15:08 GMT

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,

Reply to this Message

Dennis - 29 Apr 2008 16:18 GMT

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.

> 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
[quoted text clipped - 3 lines]
>
> Thank you,

Reply to this Message

Damon Heron - 29 Apr 2008 16:18 GMT

open table in design view and rename the fields. You can also drag them to
various positions if you want.

Damon

>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
[quoted text clipped - 6 lines]
>
> Thank you,

Reply to this Message