Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Changing Records.

Changing Records.

Changing Records.

I have a table that contains a set of areas

ID     Text
1      Area1
2      Area2
3      Area3
4      Area4
5      Area5
6      Area6

What I would like to do is alter that table so that area1,2 now become area1, area3 and 4 become area2 and areas 5 and 6 become area 2.

The people who would be doing this do not have much access skills so is there an easy way of doing this.  As there are hundreds of areas to change and the link to other tables.

Replies continue below

Recommended for you

RE: Changing Records.

Hi Escape...
I think the first thing I would do is make a "safety" field right beside your Area text field just as a guide. In the table view copy the entire column and paste it in to the new one.
Now as your differences are random we'll do this somewhat manually: In your Area field do a find/replace Area1 with "Escape". Do a find/replace Area2 with "Escape". Do a find/replace Area3 with "UK". Same again for Area4...Do you see what we're doing? Once all your areas are renamed and you're happy with the results, do a find/replace for "Escape" and change it to Area2 and so on. All done? Delete that "safety" field. This goes a lot faster than you think it might, and although there are programmatic ways to approach this, this is a method anyone can use. Enjoy!


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close