By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,842 Members | 2,154 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,842 IT Pros & Developers. It's quick & easy.

If Then Statement

P: 1
Hi!

I have a query in access with 2 column. In Excel my formula would be :
Expand|Select|Wrap|Line Numbers
  1. =if(or(col 1="true", col 2="true"),"exempt","")
What can I use in Access to achieve the same result?
Mar 28 '12 #1
Share this Question
Share on Google+
2 Replies


Rabbit
Expert Mod 10K+
P: 12,335
The IF function in Access is IIF. There is no OR function but you can use OR like an operator.
Mar 28 '12 #2

NeoPa
Expert Mod 15k+
P: 31,306
Something like the following I expect :
Expand|Select|Wrap|Line Numbers
  1. =IIf([Col 1] Or [Col 2], 'Exempt', '')
Mar 28 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.