Query the base table to sort out by your criteria, for example ******* SELECT * form MY_TABLE WHERE Benzene >= 0.02 INTO High_Benzine (or what ever table name you want) ***************
Now, from layer control, Add this new query High_Benzine. Go to Display>Style Over ride on layer control and set up the text for Box, background color Red , font color Black. Repeat for each contaminate. Save the workspace, and these queries and tables will refresh each time you open the workspace. Have you tried a thematic map based on ranges? William "Woody" Woodruff Zoning Administrator Charter Township of Union, Isabella County, Michigan (989) 772 4600 EXT 41 Visit our web site at http://www.geocities.com/ctuzoning/index.htm -----Original Message----- From: su chen [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 2:12 PM To: [EMAIL PROTECTED] Subject: MI-L SUM: labeling Hello, Thanks for quick responses from Mark Clute, Trammell, Nathaniel A. Tim.Nuteson, Charles Kane on my first question. It works good to use Chr$(13) to separate the rows in the label. For my second question, it seems like I made a wrong description, what I really mean is how can I highlight or differentiate the records that exceed the regulated criteria in the label? I hope it will be looks like this Benzene: 0.02(highlight with red color) Ethylbenzene: 0.03 Toluene: 0.4 Xylenes: 11 (hightlight with yellow color) Can anybody suggest me how to do this? Many thanks My original question: Hello, lists: Can anybody give me some advices on labeling (my special case)? I got a table which include 8 columns, the first one is BHID, the second to eighth are concentration for different contaminants. i.e BHID Benzene Ethylbenzene Toluene Xylene 1 0.02 0.03 0.4 11 What I want to do now is instead of creating maps for different contaminants, I would like to include all the contaminants information on one map. I tried this way: 1. created a new column which include all the contaminants (i.e Benzene: 0.02 Ethylbenzene: 0.03 Toluene: 0.4 Xylene: 11) 2. label the new column Questions: 1. It seemed work, but it is in one row, can I have it in different rows, which will look better? 2. since some concentration records for contaminants were above than the criteria, Can anybody suggest me a way to highlight those records in MAPINFO? Thanks a lot and will sum! __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 4673 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 4693
