if this or this then syntax 1

mibeach7 · Sep 10, 2003

This syntax is not working, get error message needing more ((())). Any ideas how to set this up right. thanks alot. rm

if {GROUP_DAYS_SUPPLY.DAYS_BP1} is null or ({GROUP_DAYS_SUPPLY.DAYS_LIMIT}*{GROUP_DAYS_SUPPLY.MAX_FILLS}) < {GROUP_DAYS_SUPPLY.DAYS_BP1} then "1"

else if {GROUP_DAYS_SUPPLY.DAYS_BP2} is null or ({GROUP_DAYS_SUPPLY.DAYS_LIMIT}*{GROUP_DAYS_SUPPLY.MAX_FILLS}) < {GROUP_DAYS_SUPPLY.DAYS_BP2} then "2"

else "3"

vidru · Sep 10, 2003

Try:

Code:

if isnull({GROUP_DAYS_SUPPLY.DAYS_BP1}) or ({GROUP_DAYS_SUPPLY.DAYS_LIMIT}*{GROUP_DAYS_SUPPLY.MAX_FILLS}) < {GROUP_DAYS_SUPPLY.DAYS_BP1} then &quot;1&quot;

else if isnull({GROUP_DAYS_SUPPLY.DAYS_BP2}) or ({GROUP_DAYS_SUPPLY.DAYS_LIMIT}*{GROUP_DAYS_SUPPLY.MAX_FILLS}) < {GROUP_DAYS_SUPPLY.DAYS_BP2} then &quot;2&quot;

else &quot;3&quot;

-dave

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

if this or this then syntax 1

mibeach7

MIS

vidru

Programmer

Similar threads

Part and Inventory Search

Sponsor