EricC Posted April 1, 2009 Share Posted April 1, 2009 I have a customer that owns 90 stores. He will be providing me with a mailing list on a monthly basis. For each record in the mailing list, I need to determine the CLOSEST store to that address. I'm sure there are a billion zip codes across the U.S., so writing a rule that matches the zip code is not practical. I'm thinking I need some type of solution that will calculate the distance between the mailing address zip code and the store zip codes, and select the one which is closest. Any ideas would be greatly appreciated! Link to comment Share on other sites More sharing options...
This topic is now archived and is closed to further replies.