ignoring the falsepart in IIF Function

[steveh65]

can someone please help me with this IIF Function in a Query. I want
to write an IIF statement that only performs an action if the truepart
= true. If the truepart = false then I want the statement to perform
no action. is this possible using iif statement. If it is not then
is there another Access function that will give me the desired
results.

Thanks
Steve

 

[John W. Vinson]

can someone please help me with this IIF Function in a Query. I want
to write an IIF statement that only performs an action if the truepart
= true. If the truepart = false then I want the statement to perform
no action. is this possible using iif statement. If it is not then
is there another Access function that will give me the desired
results.

Thanks
Steve

What's the context, Steve? An IIF statement in a query doesn't PERFORM
anything - it returns a value. If you want it to return a NULL value, do so:

IIF(<condition>, <value if true>, NULL)

If you want to "perform an action", please explain.


John W. Vinson [MVP]