Use query to Calculate Distance with geocodes or Lat/Lon

E

efandango

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.
 

Ask a Question

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I use this complex function with a query 19
Append Geocode Data from Text File (via Query) Not Working 3
Plot Shapes on World Map based on Long and Lat. 2
Tiger/Line Data 2
Calculating distance with radians 11
Distance calculation for lat/lon's? 5
SQL ORDER BY Alias column 1
array UDF not recalculating correctly 2

Top