Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [Longitude OF START point] may have TO manually enter
- [Lattitude OF START point] may have TO manually enter
- [latitude] USE latitude FROM DATA SET
- [longitude] USE FROM DATA SET
- ACOS( SIN([Longitude OF START point]*PI()/180)*SIN([latitude]*PI()/180) + COS([Longitude OF START point]*PI()/180)*COS([latitude]*PI()/180)*COS([longitude]*PI()/180-([Lattitude OF START point])*PI()/180) ) * ((6371*2)/3) AS [Distance]
Advertisement
Add Comment
Please, Sign In to add comment