1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Access97 Query on splitting data into different fields

Discussion in 'Business Applications' started by Brian Fowler, Sep 11, 2004.

Thread Status:
Not open for further replies.
  1. Brian Fowler

    Brian Fowler Thread Starter

    Joined:
    Sep 5, 2004
    Messages:
    93
    I run Access97
    I have 20000+ addresses I want to rearrange

    Old Fields
    ADDRESS1
    ADDRESS2
    ADDRESS3
    ADDRESS4
    ADDRESS5


    New Fields
    Address1
    Address2
    PostCode
    Town
    County
    Country

    So for example in old fields 1-4 we could have post codes in any field
    So for cost code Dublin 1 I want to be able to say Find Dublin 1 and Copy/Paste/Move to PostCode. It means searching through the 5 old fields and putting the identified data into the Post Code

    Any help would be appreciated

    Brian
    Dublin, Ireland
     
  2. melonhead

    melonhead

    Joined:
    May 6, 2002
    Messages:
    882
    I'm not quite sure from your explanation about your old fields. Do they have post codes intermixed with addresses, etc?

    You should be able to do an update query if I am understanding you correctly. For example you could put the criteria in city name as "dublin" and in post code in the row to update you could type in the zip for Dublin and then hit update now and it will automatically add the correct code to anyone with the city of dublin. This may be practical if you have lots of dublins, lots of other cities names. However, if you only have one each of cities, this would definitely not be the solution.

    Good luck.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/272693

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice