Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 2 of 2

Counts By Zip Code

This is a discussion on Counts By Zip Code within the MapPoint Desktop 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 ...

  1. #1
    Jim Grace is offline Junior Member White Belt
    Join Date
    Dec 2002
    Posts
    4

    Counts By Zip Code

    This seems to be a very easy problem, but I can't for figure it out.

    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.,.

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    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
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Exposing MapPoint transaction counts to our Customers
    By routesmith in forum Bing Maps and MapPoint Web Service
    Replies: 0
    Last Post: 01-16-2006, 09:49 AM
  2. how to get counts
    By cambridgeways in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 05-28-2005, 02:40 PM
  3. Zip Code Counts to Territories
    By RogerMcc in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 10-24-2002, 08:57 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83