Distance calculation

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

1 Like

Thank you Steve…will go through this documentation and give you feedback on how I go

1 Like