This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Distance calculation

Posted on 08-18-2021 03:22 PM
dessie_moonsamy
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

Hi All

I am looking for a way to calculate the distance between 2 tables and show me a dropdown list of the stores that fall within a particular radius.

I have a table of stores and I have a table of sites. Both tables have GPS coordinates. I want to be able to allocate a store to a site depending on the distance from the site. The radius is 5km

Please can you advise on the expression I should use to give me the dropdown list.

Stay Blessed
Dessie

0 2 134
Topic Labels
0 Likes
2 REPLIES 2

Posted on --/--/---- --:-- AM
Steve
Platinum 4
Platinum 4
Reply posted on --/--/---- --:-- AM

Posted on --/--/---- --:-- AM
dessie_moonsamy
Bronze 1
Bronze 1
In response to Steve
Reply posted on --/--/---- --:-- AM

Thank you Steveโ€ฆwill go through this documentation and give you feedback on how I go

Top Labels in this Space