Wendy, not sure why you want to do this but try this formula
IIF( IN-RANGE(PODetail.POLine, 1, 1000) AND MiscCode= 'FR',
STRING(PODetail.POLine,'>>>>9'), '')
Regards
Jim Stetter
-----Original Message-----
From: Wendy Pursche [mailto:wpursche@...]
Sent: Tuesday, August 15, 2000 7:33 AM
To: Vantage egroups list
Subject: [Vantage] Another RB IF statement question
Another question for you RB gurus. I would like my PO Line field to look
for the range between 1-1000 and display what it finds. I have written the
IF statement the way I thought it would work, but of course it doesn't.
Ideas??
IIF(PODetail.POLine =
NUM-ENTRIES('1','1000') And MiscCode = 'FR', '',
STRING(PODetail.POLine,'>>>>9'))
Thanks!
Wendy Pursche
Network Administrator
Schmald Tool & Die, Inc.
(810) 743-1600 ext.323
wpursche@...
[Non-text portions of this message have been removed]
IIF( IN-RANGE(PODetail.POLine, 1, 1000) AND MiscCode= 'FR',
STRING(PODetail.POLine,'>>>>9'), '')
Regards
Jim Stetter
-----Original Message-----
From: Wendy Pursche [mailto:wpursche@...]
Sent: Tuesday, August 15, 2000 7:33 AM
To: Vantage egroups list
Subject: [Vantage] Another RB IF statement question
Another question for you RB gurus. I would like my PO Line field to look
for the range between 1-1000 and display what it finds. I have written the
IF statement the way I thought it would work, but of course it doesn't.
Ideas??
IIF(PODetail.POLine =
NUM-ENTRIES('1','1000') And MiscCode = 'FR', '',
STRING(PODetail.POLine,'>>>>9'))
Thanks!
Wendy Pursche
Network Administrator
Schmald Tool & Die, Inc.
(810) 743-1600 ext.323
wpursche@...
[Non-text portions of this message have been removed]