D
Dan
I am trying to find the distance between two zip codes and i found this
equation on line:
select
acos(
( sin(z1.latitude * 0.017453293)*sin(z2.latitude * 0.017453293) )
+
( cos(z1.latitude * 0.017453293) *
cos(z2.latitude * 0.017453293) *
cos((z2.longitude*0.017453293)-(z1.longitude*0.017453293))
)
)
* 3956 as distance
from [zip code info] z1, [zip code info] z2
where z1.zipcode = 'mi49512' and z2.zipcode = 'mi49401';
however access keeps telling me that the acos function is not defined. I
looked it up at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_aa-az_5a5v.asp
so i was wondering if i am doing something wrong or if access does not
support it.
Is there anyother way to calculate the distance between zip codes in access
equation on line:
select
acos(
( sin(z1.latitude * 0.017453293)*sin(z2.latitude * 0.017453293) )
+
( cos(z1.latitude * 0.017453293) *
cos(z2.latitude * 0.017453293) *
cos((z2.longitude*0.017453293)-(z1.longitude*0.017453293))
)
)
* 3956 as distance
from [zip code info] z1, [zip code info] z2
where z1.zipcode = 'mi49512' and z2.zipcode = 'mi49401';
however access keeps telling me that the acos function is not defined. I
looked it up at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_aa-az_5a5v.asp
so i was wondering if i am doing something wrong or if access does not
support it.
Is there anyother way to calculate the distance between zip codes in access