MapForums
Community of VE/MapPoint Users and Developers
Counts By Zip Code
This is a discussion on Counts By Zip Code within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; This seems to be a very easy problem, but I can't for figure it out. I have a file of ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
12-09-2002
| |||
| |||
| Counts By Zip Code I have a file of 92,000 customer records. Each record has a zip code. At the most I have 90 different zip codes on the file. I want to map these 92000 records by their zip code, and then color code the zip codes by the count of customers in each zip code, so I can see which zip codes have the highest counts, on down. How do I make ranges that state my count levels: 0-500 is red 501-1000 is blue etc.,.         |
|
12-09-2002
| ||||
| ||||
|
Jim, You're right, it should be easy.. if you have Access and can quickly do a Group By | Sum on those fields. Basically you need to re-arrange your data so MapPoint can understand it. There should be one column with unique records for the zip codes, and another with a count of customers in each. Eric
__________________ |
 |
| Tags |
| code, counts, zip |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Exposing MapPoint transaction counts to our Customers | routesmith | MapPoint Web Service and Virtual Earth | 0 | 01-16-2006 10:49 AM |
| how to get counts | cambridgeways | MapPoint 2006/2009 Discussion | 0 | 05-28-2005 03:40 PM |
| Zip Code Counts to Territories | RogerMcc | MapPoint 2006/2009 Discussion | 3 | 10-24-2002 09:57 PM |
All times are GMT -5. The time now is 06:35 PM.
