nested compound boolean IIf statements

L

Linton

Hi, I need to construct the following:
IIf([field1]Is Not Null And [field2] Is
Null,"true","false").

I can make it work without the Boolean operator and the
second half of the statement, i.e. IIf([field1] Is Not
Null,"true","false"), but can't with the "And" and the
second logical operation. Is there a way to place
multiple boolean logical operations in an IIf statement?
I'm doing all this in a query, and ultimately need to
build something like the following:

IIf(expression,true,IIf(expression,true,IIf
(expression,true, ......
 

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