Calculte distance between two points

If I have a table with Locations, Latitude, and Longitude, is there a way with MS Access to calculate the distance between them?

I'd have a form with two comboboxes.  The user would select two different locations in those comboboxes.  Then in a text box on the form would be the distance between them.

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Here is something that is in VB.

Here's a link with an Access sample already built - get rid of the " -- " strings I used to break the link.

http -- :// -- www  -- .access-programmers -- .co -- .uk -- /forums/showthread.php?t=225339
SteveL13Author Commented:
You both posted the same solution 7 minutes apart.  And it works!
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

Jeff types faster:)
SteveL13Author Commented:
Unsure of the rules.  Do I award to both of you or the first one?  I'm not sure I've ever had exactly the same solution so close to one another.
I think the posting order is somewhat out of our control so on any given day, I could have ended up first.  There is no hard rule but if we each posted the same answer minutes apart I would be OK with splitting the points were I in first but awarding all the points to Jeff isn't a problem for me either since technically he beat me.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.