Tim's solution seems to be the best for my needs. Worked like a charm. But, like all good problems, more than one solution is available.
Ben Greenberg suggested: What about quering the non-zero cells, then adding the query result as a layer and labeling the newly added query layer instead of the base table. And Uffe Kousgaard said: Create a string field with the same value as your thematic field, but replace "0" with an empty string. Now use that for labeling. Thank you all very much. Troy Rural Metro Fire / Southwest Ambulance "Tim.Nuteson" <[EMAIL PROTECTED]> 04/29/2004 13:44 To "Troy Wiora" <[EMAIL PROTECTED]> cc Subject RE: MI-L Newbie Label Question Troy, I just needed to do this today, Make your label expression: Format$(FIELD,"#") where FIELD is your field or expression or whatever. Tim Nuteson Target -----Original Message----- From: Troy Wiora [mailto:[EMAIL PROTECTED] Sent: Thursday, April 29, 2004 3:36 PM To: [EMAIL PROTECTED] Subject: MI-L Newbie Label Question Not that I'm really a newbie, but I'm sure this is a newbie type question, there must be something I'm overlooking, like when you try to take your pants off before removing your shoes, it will work, but you are sure there must be a better way. Anyway, is there a way to not label cells with a zero value when you label a thematic map? I do a lot of "calls per square mile" stuff and sometimes, there's a lot of square miles with no calls. Deleting those zeros, while exciting and suspenseful, sometimes takes a while. Any thoughts? Thanks, Troy Rural Metro Fire / Southwest Ambulance ----------------------------------------- This communication may contain confidential and/or proprietary information and may not be disclosed to anyone other than the intended addressee. Any other disclosure is strictly prohibited by law. If you are not the intended addressee, you have received this communication in error. Please notify the sender immediately and destroy the communication including all content and any attachments. Thank you. ----------------------------------------- This communication may contain confidential and/or proprietary information and may not be disclosed to anyone other than the intended addressee. Any other disclosure is strictly prohibited by law. If you are not the intended addressee, you have received this communication in error. Please notify the sender immediately and destroy the communication including all content and any attachments. Thank you.
