Another RB IF statement question


(system) #1
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]

(system) #2
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]