Use query to Calculate Distance with geocodes or Lat/Lon

Discussion in 'Microsoft Access VBA Modules' started by Guest, Oct 23, 2007.

  1. Guest

    Guest Guest

    I have a table with a number of addresses with geocodes; I want to say to the
    query, find all addresses (geocode) within a 2 mile radius of a given geocode
    (which is on the parent form). Does anyone know how I can do this?

    PS: the geocodes will only cover a 10 mile radius, so earth curvature is not
    an issue.
     
    Guest, Oct 23, 2007
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Leah

    Calculate rolling 12 mo period

    Leah, Jul 17, 2003, in forum: Microsoft Access VBA Modules
    Replies:
    2
    Views:
    943
  2. Alberto Uttranadhie

    Calculate date differences

    Alberto Uttranadhie, Nov 5, 2003, in forum: Microsoft Access VBA Modules
    Replies:
    2
    Views:
    321
    Alberto Uttranadhie
    Nov 5, 2003
  3. Guest
    Replies:
    0
    Views:
    289
    Guest
    Oct 18, 2007
  4. Guest
    Replies:
    1
    Views:
    1,252
    John Nurick
    Oct 24, 2007
  5. efandango

    How can I get Yahoo Geocodes into Access?

    efandango, Oct 25, 2008, in forum: Microsoft Access VBA Modules
    Replies:
    15
    Views:
    1,212
    efandango
    Oct 27, 2008
  6. tannie
    Replies:
    1
    Views:
    243
    kc-mass
    Jul 25, 2009
  7. Jignesh

    I want use accounting software in INDIA so pls help me for use

    Jignesh, Apr 22, 2010, in forum: Microsoft Access VBA Modules
    Replies:
    2
    Views:
    662
    Arvin Meyer [MVP]
    Apr 22, 2010
Loading...