iif statement

[geebee]

hi,

I have the following:

SELECT "all resolved" AS ResolvedStatus,
[1calltotals2Rjuly130_final].ResolvedDt, [1calltotals2Rjuly130_final].Expr1,
"line5" AS line
FROM 1calltotals2Rjuly130_final
GROUP BY "all resolved", [1calltotals2Rjuly130_final].ResolvedDt,
[1calltotals2Rjuly130_final].Expr1;


I would like to make the query depend on whether or not there is a value
entered in a form. For example, if the form's field is null, then use the
above. If it is not null, then use another table. I tried to change the
query to:

iif(forms![test]![field1] <>"",SELECT "all resolved" AS ResolvedStatus,
[1calltotals2Rjuly130_final].ResolvedDt, [1calltotals2Rjuly130_final].Expr1,
"line5" AS line
FROM 1calltotals2Rjuly130_final
GROUP BY "all resolved", [1calltotals2Rjuly130_final].ResolvedDt,
[1calltotals2Rjuly130_final].Expr1;, SELECT ResolvedStatus,
[1calltotals2Rjuly130_finaltemp].ResolvedDt,
[1calltotals2Rjuly130_finaltemp].Expr1, "line5" AS line
FROM 1calltotals2Rjuly130_finaltemp
GROUP BY "all resolved", [1calltotals2Rjuly130_finaltemp].ResolvedDt,
[1calltotals2Rjuly130_finaltemp].Expr1; ))

But I am having no luck. Could someone please help?

Thanks in advance,
geebee

 

[Ofer Cohen]

Check if you got your answer in the other post

http://www.microsoft.com/office/com...ries&mid=b9147e8a-54cd-4d9a-bc31-400d787b5293