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
