IIF(AND) statement

E

Eva

Hi
I have a number of things I need to test in the query. I need to use IIF
statement with AND (for example in Excel you can do it),.
Example
I need this
IIf (and(cat="HS",cat2="JTK",cat3="NT"),"1","2")
how to do it in access?
 
X

XPS350

Hi
I have a number of things I need to test in the query. I need to use IIF
statement with AND (for example in Excel you can do it),.
Example
I need this
IIf (and(cat="HS",cat2="JTK",cat3="NT"),"1","2")
how to do it in access?

--

Greatly appreciated

Eva


IIf (cat="HS" and cat2="JTK" and cat3="NT","1","2")

Groeten,

Peter
http://access.xps350.com
 
E

Eva

Hi
I used finaly or, but your post helped me to think it over. Thank you!
--


Greatly appreciated

Eva
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top