 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / July 2007ignoring the falsepart in IIF Function
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 >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 [quoted text clipped - 5 lines] >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] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.