Title

Calculating Distance to Subject using address or lat/lon

Post

My questions to date have been pretty basic stuff. Now I have a challenge for all of you FMP guru's. How do I auto calc geographic distances between two points using either an address or lat/lon. The report I'm doing need to compare the distance of a group of properties to a single subject property that will be at the top of the report. So I will have a field "Distance to Subject" that will then be calculated for each record in the report using the address or lat/lon. Hopefully someone has done this and can help me out.

For the latter, you can do a google search to get a formula that computes distance between to points specified in lat and long. Addresses can be used with google maps, to get lat and long values to plug into such a formula.

Other's here in the forum have done this, but I forget the formula and the precise details in how to get lat, long from google maps.