How to calculate distance?
Posted on 2011-09-29
I how can I calculate distance between 2 points. I have created a table with the name of towns, post codes and coordinates.
The table look like this:
Town/Site Post Code Longitude Latitude
Moranbah 4740 148.04577 -22.00091
I would like to use the table to give me the distance between the 2 points in Km's.
So If I created 2 combo box's To: and From: a Message Box would appear and say the distance between i.e Moranbah and Dysart is 60.271Km.
Is this possible to do using MS Access 07?
If so where do I begin?