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
