PC Review


Reply
Thread Tools Rate Thread

Use query to Calculate Distance with geocodes or Lat/Lon

 
 
=?Utf-8?B?ZWZhbmRhbmdv?=
Guest
Posts: n/a
 
      23rd Oct 2007
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.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I get Yahoo Geocodes into Access? efandango Microsoft Access 15 27th Oct 2008 07:54 PM
How can I get Yahoo Geocodes into Access? efandango Microsoft Access VBA Modules 15 27th Oct 2008 07:54 PM
Grouping addresses by coordinates - geocodes? Janet Microsoft Access 1 27th Aug 2008 06:56 PM
Use query to Calculate Distance with geocodes or Lat/Lon =?Utf-8?B?ZWZhbmRhbmdv?= Microsoft Access Queries 0 23rd Oct 2007 03:52 PM
calculate time/distance =?Utf-8?B?S0pP?= Microsoft Excel Programming 3 20th Apr 2005 09:53 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:42 PM.