[AccessD] Where claise in IIf query

Oleg_123 at xuppa.com Oleg_123 at xuppa.com
Mon Nov 10 12:42:31 CST 2003


Hey Group, I am not able to put conditions in queries whee I use IIF. What
is the alternate solution ?
This works ---

SELECT Table3.amount,
IIf([Amount]="4 ","777",IIf([Amount]="2 ","060010",IIf([Amount="3
","055"))) AS HH,
IIf([HH]="060010 ","zzz",IIf([HH]="777 ","yyy")) AS JJ
FROM Table3;

however when  Iput in WHERE

SELECT Table3.amount,
IIf([Amount]="4 ","777",IIf([Amount]="2 ","060010",IIf([Amount="3
","055"))) AS HH,
IIf([HH]="060010 ","zzz",IIf([HH]="777 ","yyy")) AS JJ
FROM Table3
WHERE JJ = "zzz"

doesn't work. I tried inserting GROUP BY by all statements, and then
HAVING, but doesn't work either...


-----------------------------------------
Get Breaking News from CNN, ABC, NBC, CBS Now.
http://www.xuppa.com/news/?link=webmail




More information about the AccessD mailing list