Alpha Video Training
Results 1 to 3 of 3

Thread: Would like to search by distance

  1. #1
    Member
    Real Name
    Marilyn Wallace
    Join Date
    Aug 2003
    Posts
    58

    Default Would like to search by distance

    I would like to be able to create a report that lists all of my client companies that are within a certain radius from a selected city. I have client addresses in the client table. It would be wonderful if it just worked based upon the city (rather than the street address). Does anyone know of a way to do this?

    Thanks in advance!

  2. #2
    Alpha Software Employee Lenny Forziati's Avatar
    Real Name
    Lenny Forziati
    Join Date
    Nov 2001
    Location
    Alpha Software
    Posts
    4,699

    Default

    I've moved this to A5v6 from "forum support" which is for issues related to the message board only. If you are asking about a different version, let me know which and I will move this to the correct place.

    -Lenny

  3. #3
    VAR csda1's Avatar
    Real Name
    Ira J Perlow
    Join Date
    Apr 2000
    Location
    Boston, Massachusetts, USA
    Posts
    3,530

    Default

    Marilyn,

    This is doable using geo coding. By looking at the latitude & longitude of a zipcode (typically by looking into a table with this info), the distance can be calculated between 2 points on the globe. These formulas are widely published and available on the internet, including an example on Peter Wayne's www.learningalpha.com site.

    However, practice can be a bit trickier than just applying the formula's. If one is not careful, they get divide by zero's and other errors if you pick a bad pair of input values.

    I have a package of Alpha 5 Geo-coding routines that are very powerful (and extremely fast - about .2 sec to search 50k records, compared to 30 seconds for most), but I am putting the final touches on the licensing issues. If you have an immediate need for something, contact me at the email below.
    Regards,

    Ira J. Perlow
    Computer Systems Design


    CSDA A5 Products
    New - Free CSDA DiagInfo - v1.39, 30 Apr 2013
    CSDA Barcode Functions

    CSDA Code Utility
    CSDA Screen Capture



Similar Threads

  1. Distance Calculator using Longitude/Latitude
    By Andy Dibble in forum Alpha Five Version 6
    Replies: 6
    Last Post: 02-17-2005, 02:02 PM
  2. Zipcode & distance
    By richarddsmith in forum Alpha Five Version 5
    Replies: 17
    Last Post: 07-13-2003, 10:11 AM
  3. Vertical distance
    By Janet Seber in forum Alpha Five Version 5
    Replies: 2
    Last Post: 02-12-2003, 10:35 AM
  4. Search on Index - Search Key PopUp Dialog Bog
    By Jeff Wells in forum Alpha Five Version 5
    Replies: 1
    Last Post: 02-06-2003, 11:18 AM
  5. Zip Code distance finder
    By John Magno in forum Alpha Five Version 5
    Replies: 1
    Last Post: 11-22-2002, 09:38 AM

Bookmarks

Posting Permissions

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