IIF(AND) statement

[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?

 

[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

 

[KARL DEWEY]

Try this --
IIf (cat="HS" or cat2="JTK" or cat3="NT","1","2")

 

[Eva]

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


Greatly appreciated

Eva