-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: kalpesh
Message 3 in Discussion
In MS-Access 2002, this works
update bdetail set user =
IIF(BModelID in ('a','b','x','y'), 'Yes', 'No')
Should work in lower ver as well
Some things could be of help to you
You can nest several IIFs inside to build a CASE kind of a statement similar to Oracle
eg
update bdetail set user =
IIF(BModelID in ('a','b','c','d'), '10',
IIF(BModelID in ('w','x','y','z') , '30', 0)
Above is similar to pseudocode
switch (BmodelID)
{
case 'a', 'b', 'c', 'd'
return 10;
break;
case 'w', 'x', 'y', 'z'
return 30;
break;
default // similar to case else
0;
}
Look at what Aamir has posted about understanding of IIF
IIF = IF the condition is true (arg1, evaulation expression, shud be a boolean value)
do this thing (arg2, true part)
else
do some other thing (arg3, false part)
HTH
Kalpesh
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/mumbaiusergroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]