Ahhh, but what if the low address range has a "0" on one side or the other and you want to show the true low/high range?
In other words, you actually desire "the minimum greater than zero" Thanks to Simon O'Keefe for help with this... left$(str$(minimum(FROMLEFT,FROMRIGHT)),99*int(FROMLEFT<>0 and FROMRIGHT<>0)) + left$(str$(maximum(FROMLEFT,FROMRIGHT)),99*int(FROMLEFT=0 or FROMRIGHT=0)) So, if: FROMLEFT = 1 TOLEFT = 99 FROMRIGHT = 0 TORIGHT = 100 The above syntax will give you (1 - 100) instead as opposed to (0-100) when using "minimum" alone. Of course, the best thing here if you're gonna label with low and high range very much (which I do on all my work as well). The best thing to do is add a "LOW" and "HIGH" field in your table then label from that. Then occasionally, use the above syntax to update your "LOW" column after doing much addressing maintenance (if you do much of that). Just my .2¢ worth :)) David Reid -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trey Pattillo Sent: Wednesday, September 13, 2006 8:56 PM To: [email protected] Cc: Kenneth Hickey Subject: Re: [MI-L] multline labels here's one I use all the time be sure to set the "position" for center of the object under the field to use select expression and copy/paste the below and set the style to be "boxed" I like a light yellow background with red/blue/black letters minimum(fromleft,toleft) + "-" + maximum(fromleft,toleft) + chr$(10) + Street + chr$(10) + minimum(fromright,toright) + "-" + + maximum(fromright,toright) this produces a look the below where --- street--- is the line [- is line] 100 - 198 -----E MAIN ST ------- 101 - 199 another is minimum(fromleft,fromright) + " - " + Street + " - " + maximum(toleft,toright) which looks like with = being the the actual street line ========== 100 - E MAIN ST - 199 ============ On Wed 13 Sep 2006 19:15, Kenneth Hickey wrote: > Hey > > Can anyone tell me how to make labels with multiple lines each with > data from different fields? > > Thanks > Ken -- Trey Pattillo Failure is not an option.... It comes standard with all Microsoft products. _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.12.3/446 - Release Date: 9/12/2006 _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
