-----------------------------------------------------------

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]

Reply via email to