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

Reply via email to