IIF(AND) statement

  • Thread starter Thread starter Eva
  • Start date Start date
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?
 
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
Click to expand...


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

Groeten,

Peter
http://access.xps350.com
 
Hi
I used finaly or, but your post helped me to think it over. Thank you!
--


Greatly appreciated

Eva
 
Back
Top