MapForums
Community of VE/MapPoint Users and Developers
need help in entering quaintly against postcode
This is a discussion on need help in entering quaintly against postcode within the MapPoint 2006/2009 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 ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
08-03-2004
| |||
| |||
| need help in entering quaintly against postcode 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         |
|
08-03-2004
| ||||
| ||||
|
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
__________________ |
|
08-04-2004
| ||||
| ||||
|
You're welcome! 
__________________ |
 |
| Tags |
| entering, postcode, quaintly |
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 |
| Full UK Postcode | Anonymous | MapPoint 2006/2009 Discussion | 2 | 03-15-2004 10:46 AM |
| lat lon from uk postcode | starbuck | MapPoint 2006/2009 Discussion | 2 | 12-16-2003 09:53 AM |
| POSTCODE | gsc1ugs | MapPoint 2006/2009 Discussion | 0 | 02-06-2003 09:20 AM |
| Postcode Formatting.. | David | MapPoint 2006/2009 Discussion | 0 | 08-30-2002 06:33 AM |
| UK postcode mapping problems | Robin | MapPoint 2006/2009 Discussion | 1 | 08-08-2002 08:09 AM |
All times are GMT -5. The time now is 05:07 AM.
