Results 1 to 2 of 2
  1. #1
    kalisti is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2011
    Posts
    1

    Visual Mapping Using Zip Codes?

    Apologies if this is the wrong forum, but it seemed most accurate.



    I'm using an Access database to store the information we have on the leads from our marketing. One thing we collect is the zip code, which helps us know where our ad dollars are most converting.

    The thing is, as a number it means very little. What I'd really like is to be able to somehow create a visualized report using the zip code data, creating either a cluster map or a heat map overlaid on a map of the US.

    I assume Access doesn't have this capability itself, but I thought people might know of a solution that would integrate seamlessly with Access.

    Thanks so much for any leads!

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    kali,

    I googled this out of interest and the only thing I saw was integration with MS mappoint. I doubt that would help you though, but if you're interested of course, google it and see what resources there are.

    Additionally, your example of using color coding like heat sensor maps makes me thing of the data-driven equivalent, which would probably be weighted-averaging. That doesn't do much good to you though I know, but it is worth mentioning I suppose.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Finding subsequent codes
    By Rixxe in forum Queries
    Replies: 8
    Last Post: 09-15-2010, 02:44 AM
  2. Importing and mapping data to various tables
    By rasticle in forum Import/Export Data
    Replies: 1
    Last Post: 05-17-2010, 04:22 PM
  3. mapping problem?
    By stevenyp in forum Programming
    Replies: 2
    Last Post: 10-08-2009, 10:13 AM
  4. basic query codes
    By joms222 in forum Queries
    Replies: 1
    Last Post: 03-20-2009, 11:31 AM
  5. form - subform field mapping
    By nqirar in forum Programming
    Replies: 2
    Last Post: 03-02-2009, 01:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums