Hi,
Can any one help in this case,
if OKCUA4='' and OKCUA3 in (counties) then OKCUA2
else if OKCUA4='' and OKCUA3 not in (counties) then OKCUA3
else if OKCUA4 in (counties) then OKCUA3
else OKCUA4
I have to use "in" condition within "if"
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
It should be AND, not ORshalini11 wrote:if OKCUA4='' and (OKCUA3=counties1 or OKCUA3=counties2...) then OKCUA2
else if OKCUA4='' and (OKCUA3<>counties1 or OKCUA3<>counties1 ...)then OKCUA3
else if (OKCUA4=counties1 or OKCUA4=counties2...)then OKCUA3
else OKCUA4
if OKCUA4='' and (OKCUA3=counties1 or OKCUA3=counties2...) then OKCUA2
else if OKCUA4='' and (OKCUA3<>counties1 AND OKCUA3<>counties1 ...)then OKCUA3
else if (OKCUA4=counties1 or OKCUA4=counties2...)then OKCUA3
else OKCUA4
Or DSGuru's Index idea.
Kandy
_________________
Try and Try again…You will succeed atlast!!
_________________
Try and Try again…You will succeed atlast!!