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. Guest
    Replies:
    0
    Views:
    149
    Guest
    Oct 18, 2007
  2. Guest
    Replies:
    1
    Views:
    959
    John Nurick
    Oct 24, 2007
  3. efandango

    How can I get Yahoo Geocodes into Access?

    efandango, Oct 25, 2008, in forum: Microsoft Access VBA Modules
    Replies:
    15
    Views:
    699
    efandango
    Oct 27, 2008
  4. tannie
    Replies:
    1
    Views:
    161
    kc-mass
    Jul 25, 2009
  5. how can i use the produc key after use to code.

    , Dec 13, 2009, in forum: Microsoft Access VBA Modules
    Replies:
    0
    Views:
    181
Loading...

Share This Page