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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Leah

    Calculate rolling 12 mo period

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

    Calculate date differences

    Alberto Uttranadhie, Nov 5, 2003, in forum: Microsoft Access VBA Modules
    Replies:
    2
    Views:
    218
    Alberto Uttranadhie
    Nov 5, 2003
  3. Guest
    Replies:
    0
    Views:
    191
    Guest
    Oct 18, 2007
  4. Guest
    Replies:
    1
    Views:
    1,119
    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:
    791
    efandango
    Oct 27, 2008
  6. tannie
    Replies:
    1
    Views:
    204
    kc-mass
    Jul 25, 2009
  7. how can i use the produc key after use to code.

    , Dec 13, 2009, in forum: Microsoft Access VBA Modules
    Replies:
    0
    Views:
    241
  8. 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:
    594
    Arvin Meyer [MVP]
    Apr 22, 2010
Loading...