Sure, Left$(Str$(FIELDNAME), Int(FIELDNAME Mod 25 = 0) * Len(Str$(FIELDNAME)))
Now you can just change the 25 to what ever value you need to label. I tak eit that your column holds numbers/integer not characters Peter Horsbøll Møller GIS Developer, MTM Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -----Original Message----- From: Paul Smith [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 21, 2005 7:37 AM To: 'Stephen Chan' Cc: [email protected] Subject: RE: MI-L Label Expression Help Thanks Stephen, Mid$(str$(Fieldname),InStr(1,Right$(str$(Fieldname), 2),"00"),4) Works perfect. What about if I want to label every 25 records? 125,150,175,200 etc Any Ideas if this can be done with an expression. Paul -----Original Message----- From: Stephen Chan [mailto:[EMAIL PROTECTED] Sent: Tuesday, 21 June 2005 12:57 PM To: Paul Smith Cc: [email protected] Subject: Re: MI-L Label Expression Help I meant mid$() not left$() sorry On 6/21/05, Stephen Chan <[EMAIL PROTECTED]> wrote: > Use the following label Expression: > Left$(str$(Fieldname),InStr(1,Right$(str$(Fieldname), 2),"00"),4) > > > On 6/21/05, Paul Smith <[EMAIL PROTECTED]> wrote: > > > > Sorry I ment "possible withOUT using a SQL Select statement." > > > > > > -----Original Message----- > > From: Paul Smith [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, 21 June 2005 11:30 AM > > To: [email protected] > > Subject: MI-L Label Expression Help > > > > > > Hi Everyone, > > > > I need help with a Label Expression to only show labels which are a > > multiple of 100. > > > > I have a table with numbers 1 to 1000 and currently have the > > following expression which gives me T and F labels correctly at 100, > > 200 etc. > > > > But how do i adapt this expression to show the original value ie. > > label with 100, 200 instead of T and F. > > > > Right$(str$(Fieldname), 2)="00" > > > > I am hoping that this is possible with using a SQL Select statement. > > > > Thanks > > > > Paul > > > > > > > > -------------------------------------------------------------------- > > - > > List hosting provided by Directions Magazine | www.directionsmag.com > > | To unsubscribe, e-mail: > > [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > Message number: 16837 > > > > > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 16842 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 16844 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 16845
