I have a distance formula that works in excel but does not work on msaccess because some of the functions are not available like ACOS.
dist= Acos(Sin(lat1)* Sin(lat2)+Cos(l at1)*Cos(lat2)* Cos(long2-long1))*6371
What formula can i use to replace this and make it work on ms access?
2 results in 0.0024 seconds.
-
how to calculate distance based from lat long
-
Get the id of the next closest location
Hi.
I have an application in which the user can select a location and view it's distance from several Points Of Interests (POIs).
When I retrieve these distances, I would also like to retrieve the ID's of the locations that are the next closest and the next furthest away from each POI. eg. If we have 10 locations, each of them a mile further away from a certain POI the I would like to return: The name of the POI, The...
