----- Forwarded by Philip Lesnik/General Growth Mgmt Inc/US on 08/25/2004 02:54 PM ----- Paul Green To: Philip Lesnik/General Growth Mgmt Inc/[EMAIL PROTECTED] 08/25/2004 02:48 cc: PM Subject: Map Label Issue (Database transformation?) I have a dump from a database that I need to map with a complex label. The database is in the schema below: |--------+-----------+----------+----------------| | Mall id| STORE TYPE| Store | SQ FT | | | | NAME | | |--------+-----------+----------+----------------| | 1 | Supermkt | Shop Rite| 24000| |--------+-----------+----------+----------------| | 1 |Dept Store | Kohl's | 80000| |--------+-----------+----------+----------------| | 1 | Supermkt | Super | 40000| | | | Stop & | | | | | Shop | | |--------+-----------+----------+----------------| | 2 | Dept Store| Kohl's | 100000| |--------+-----------+----------+----------------| | 2 |Dept Store | JCPenney | 23000| |--------+-----------+----------+----------------| | 3 | Dept Store| JCPenney | 63000| |--------+-----------+----------+----------------| | 3 |Dept Store | Kohl's | 10002| |--------+-----------+----------+----------------| | 3 |Supermkt | Jewel | 80000| |--------+-----------+----------+----------------| | 3 |Dept Store | Kmart | 52310| |--------+-----------+----------+----------------| There is also a lat/lon in each row. My problem is I want to plot the point, and label the point with Mall id and ALL stores associated with that mall. As you can tell, there is no set number of stores for each mall?one mall might have one store associated with it, while another mall has 4 or more stores associated with it. The first thing I thought of doing was a crosstab query in Access. There are too many records (35,000+) to go through and make a separate column and label each record "Store 1", "Store 2", "Store 3", etc for each mall. If I could do that, I could perform the crosstab query in Access. I am kind of at a loss. Do you have any suggestions? Paul Green Analyst Market Research General Growth Properties, Inc. (312) 960-2706 ----------------------------------------- +++++++++++++++++++++++++++++++++++++++++++++++++++++++ Notice: This e-mail including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. §§ 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you. +++++++++++++++++++++++++++++++++++++++++++++++++++++++ --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 13064