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 4 of 4

need help in entering quaintly against postcode

This is a discussion on need help in entering quaintly against postcode within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hi, I really need your help, I have been trying to import data using the wizard to find out how ...

  1. #1
    tony jones is offline Junior Member White Belt
    Join Date
    Aug 2004
    Posts
    1

    need help in entering quaintly against postcode

    Hi,

    I really need your help, I have been trying to import data using the wizard to find out how many of our products have been sold by postcode, however this does not work or Iím doing something wrong.

    Below is what my excel data looks like, I have two columms detailing:

    QTY POSTCODE
    10 UB8 255
    1 UB8 111
    12 UB8 222
    2 UB8 121

    If the data was imported right I would see that we sold 15 products to the UB8 postcode area. But when I import the data it only says that we sold 4 products. It seems to be just looking at the postcode column and not the qty by postcode.

    Any Ideas?
    Thanks
    Tony

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    Hi Tony,

    Roll it up first by post code.. you should only have one record/row per post code with a sum of all sales in that zip code.. this can be accomplished with Access or a database... you should also be able to do this with Excel.

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  3. #3
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    Thanks this worked... Great
    Regards
    tony

  4. #4
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    You're welcome!
    ~ 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. Full UK Postcode
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 03-15-2004, 10:46 AM
  2. lat lon from uk postcode
    By starbuck in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 12-16-2003, 09:53 AM
  3. POSTCODE
    By gsc1ugs in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 02-06-2003, 09:20 AM
  4. Postcode Formatting..
    By David in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 08-30-2002, 06:33 AM
  5. UK postcode mapping problems
    By Robin in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 08-08-2002, 08:09 AM

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 84 85 86 87 88 89 90 91 92 93 94 95 96