MAPPOINT Q & A

Top | Post New Question | Read All | MP2K Asks Microsoft

414 scott - September 26, 2001

Using the radius tool, I would like to import a list of addresses and have MapPoint display only those that are outside a 50 mile radius around a point.

Answer:

There are a couple of different ways to approach this, but the easiest one is probably to import all addresses, add a 50-mile radius circle on the map, use this to export all addresses INSIDE the radius to Excel, and then do the little bit of work required in Excel to "subtract" these rows from the total data set.

If you're willing to do some programming, you could of course perform all the work inside MapPoint. In that case you would plot all addresses, do a simple distance calculation from each point to your chosen centerpoint, and export only those points that are >50 miles from the centerpoint. Very easy, probably no more than a couple of hours work for somebody familiar with the MapPoint object model.

Post New Answer / Follow-up

	MP2Kmag Internet