Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jul 2001
    Location
    New York City, North Carolina, USA
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Select/Sort (2000)

    Can you select and sort in reverse in a field.....e.g. NY, NY 10017
    I need to select by the zip code.....
    I have 3,279 names in an ACCESS table
    thanks much......

    If possible I need an answer ASAP for a job I must complete.....really appreciate the answer <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>

  2. #2
    Lounger
    Join Date
    Dec 2002
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Select/Sort (2000)

    Create a query using this table and add all the fields. At the end, add a field, say, "Zip" and enter like

    Zip: Right(MyField, 5)

    MyField is the field that has "NY, NY 10017". I am assuming all the zip codes are in 5 digits.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Select/Sort (2000)

    Your real problem is that you have multiple pieces of information in a single field if you are including something like "NY, NY 10017", and that is poor database design. If you put city, state and zip into separate fields you will solve a lot of problems including sorting.
    Charlotte

  4. #4
    New Lounger
    Join Date
    Jul 2001
    Location
    New York City, North Carolina, USA
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Select/Sort (2000)

    Thanks for the prompt response....I will attempt it although I am not that well versed in ACCESS.....Thanks again
    Kit

  5. #5
    New Lounger
    Join Date
    Jul 2001
    Location
    New York City, North Carolina, USA
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Select/Sort (2000)

    Thanks for your prompt response. I have since learned that the best way is to put all info in a separate field. This particular database was brought over from Word and I really didn't know how to separate it automatically before bringing it over. Believe me we don't do that any more! Need to learn more about ACCESS but I appreciate your response.
    Kit

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •