Top |
Post New Question |
Read All |
MP2K Asks Microsoft
517
Diana Martin
-
November 29, 2001
My boss is looking for a softwear program into which one can enter 100-200 names/addresses, then by typing in one address(or name), pull up a list of all addresses within, say, a 5, 10 or 20 mile radius. Will your product do this? Will MSAccess? Any recommendations are greatly appreciated!
Answer:
In MapPoint, this would work as follows. You would address match all 200 or so names and display them as pusphins. You can then do a "find" by name of a particular item. MapPoint finds the name, and selects the pushpin. You then do a Find Nearby search of a particular radius size (5, 10 or 20 miles) from this location, and MapPoint would list the items it found. Extracting the records to Excel with all the address fields is easy too - just draw a radius circle on the map and choose Export to Excel.
In other words, MapPoint is great for this. The only trick is naming the records appropriately so MapPoint just returns items from this dataset, and not a whole list of cities and villages. If you find "Smith" you get all the customer records for people called Smith, but also loads of other entities. If you preface all your records with some unique code ("XXX"), all MapPoint will find is your data. When it comes to extracting data there is no issue - all that will extract is your data, nothing else.
Post New Answer / Follow-up