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: 16840
