1 Reply Latest reply on Aug 14, 2012 2:10 PM by davidanders

    Need help creating a search for distance



      Need help creating a search for distance


      I have a database of over 5 million records all with a longitude and latitude coordinates. I need to enter a known or fixed location's longitude and latitude and get back distance (I already have the formula to find the distance). I have no idea where to start. It would be really cool if I can enter the fixed longitude, latitude and max distance from that fixed point. Example: My fixed point is "A" and I want to return all points with a 1/2 mile from my fixed point "A". Right now I do all my searching in the find mode. I hope this makes sense to someone out there.