----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: aamirOnline Message 2 in Discussion Hi, In ms access so far as i know there is no case when statement like sql server or oracle, you can use IIF function instead of case when in ms access. iif has following format. iif (expression, value_if_exp_is_true, value_if_exp_is_false) regards M Aamir Maniar System Analyst (CWS), Freelance OOPD Consultant [EMAIL PROTECTED] ----------------------------------------------------------- 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]
