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.

Database Help?

Discussion in 'Business Applications' started by Airifyltd, Jul 17, 2017.

Advertisement
  1. Airifyltd

    Airifyltd Thread Starter

    Joined:
    Jul 17, 2017
    Messages:
    4
    Hello everyone, I am wanting some help on the best way to set up some sort of database/spreadsheet/form to help our business please. All we are wanting to know is if I enter a postcode it will tell me what agency it belongs to eg 7614 = Northshore. Is there a google form or programme that can do this ? Thanks
     
  2. Sponsor

  3. etaf

    etaf Wayne Moderator

    Joined:
    Oct 2, 2003
    Messages:
    62,722
    how many agency are there
    how many post codes
    are they all numbers ?
    i'm in uk and we have letters and numbers
    would an agency cover a region like
    76 or 761
    not sure if thats how post codes work

    uk
    have
    regions
    say
    kt
    that then splits into smaller area
    kt2
    kt22
    kt22 2
    kt22 2a
    kt22 2aa
     
  4. Airifyltd

    Airifyltd Thread Starter

    Joined:
    Jul 17, 2017
    Messages:
    4
    The postcodes are all 4 digit numbers and there are maybe a thousand of them and we have say 30 agencies
     
  5. etaf

    etaf Wayne Moderator

    Joined:
    Oct 2, 2003
    Messages:
    62,722
    can those digits be broken down as mentioned?
    so that
    76 = 1 agency
    ?
     
  6. Airifyltd

    Airifyltd Thread Starter

    Joined:
    Jul 17, 2017
    Messages:
    4
    no sorry have to stay as a 4 digit
     
  7. etaf

    etaf Wayne Moderator

    Joined:
    Oct 2, 2003
    Messages:
    62,722
    i had hoped we could maybe reduce the need to create a huge datafile for lookups
    as you could have entered the four numbers and extracted the first two and then look that up

    if agencies all cover the range of numbers
    ie
    7614 = Northshore
    7615 = Southshore
    7616 = Westshore

    then you will need to create the full list of numbers and then use a lookup

    like

    7614 = Northshore
    7615 = Southshore
    7616 = Westshore
    7617 = Northshore
    7618 = Southshore
    7619 = Westshore
     
  8. Airifyltd

    Airifyltd Thread Starter

    Joined:
    Jul 17, 2017
    Messages:
    4
    Hi yes that is correct ! what is a lookup and what programme do i use ? Thanks
     
  9. etaf

    etaf Wayne Moderator

    Joined:
    Oct 2, 2003
    Messages:
    62,722
    you will need to create a sheet with all the postcodes in and next to each code the agency

    So Sheet2 of a spreadsheet would have in column A all the postcodes
    and in Column B all the agencys matched against each postcode

    then in sheet 1 you can use a lookup
    vlookup() or index match()
    to look up the value

    I have setup a small example

    in sheet 1 cell A2 you enter the postcode
    and in cell B2 would appear the agency
    based on the values on sheet2

    see attached
     

    Attached Files:

  10. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,232
    Etaf, may I suggest that a Combo dropdown may be a good alternative to the lookup method as combos have intuitive typing, at least Access ones do.
     
  11. etaf

    etaf Wayne Moderator

    Joined:
    Oct 2, 2003
    Messages:
    62,722
    of course OBP chip in
     
  12. draceplace

    draceplace

    Joined:
    Jun 8, 2001
    Messages:
    2,404
    My experience is Drop Downs with over 250 entries can become cumbersome to the end user, depending on the data.
     
  13. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,232
    Only if the data is not ordered correctly and or they do not know how to use the Combo.
    If you click on the Combo aperture and then start typing the combo will jump to the first item in the list that matches as you type. Which is quicker than typing somethging in full.
     
  14. Sponsor

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...

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