Tony, Try the following label expression. Left$(Str$(Field*10),Len(Str$(Field*10))-1)
Seems to work for me! Cheers Rex GIS Officer City of Rockingham Civic Boulevard Rockingham Western Australia PO Box 2142 Rockingham WA 6967 Direct Tel. 9528 0430 Email : [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tony Baylis Sent: Wednesday, January 18, 2006 11:35 AM To: Mapinfo-L Subject: [MI-L] Labelling numeric fields Afternoon all I have a large table with a numeric field I need to label BUT it contains many zero values. I do not wish to label the zeroes. Can you use an expression in the label tool such as: If FIELD>0 Then FIELD If this does not work does anyone have any other work around? Cheers Tony -- Tony Baylis Spatial Information Specialist Resource and Exploration Mapping Suite 8, 290 Boundary St Spring Hill QLD 4000 Ph 3832 1600 Fax 3832 1603 Mob 0419 759 131 Email [EMAIL PROTECTED] www resexmap.com.au _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l This email may contain advice and comment on a matter which is currently being considered by Council or may be considered by Council in the near future. Any advice or comments are the views of the Officer sending this email and should not be construed as a formal Council position. The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. This footnote also confirms that this email message has been swept by McAfee for the presence of computer viruses. _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
