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

    Sep 5, 2004
    I run Access97
    I have 20000+ addresses I want to rearrange

    Old Fields

    New Fields

    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

    Dublin, Ireland
  2. melonhead


    May 6, 2002
    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!

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