I have a query that is supposed to set a value for the STATUS of the record as part of the query. That is, depending on the status of various check boxes and date fields the STATUS field of the query record changes (i.e. from "Study Phase" to "Awaiting Closeout" and several other phases).
I'm not having any difficulties with the dates and use Null values effectively to drive the decision tree. It is when I tried to add in a Yes/No field that I can't get the syntax right. The field label is "IM" and here are a few of the things I've tried:
Code:
IIf(([IM])=-1,...)
IIf(([IM])=False,...)
The ellipsis marks the THEN/ELSE portion of the IIf statement. Basically, all I'm looking to do is incorporate the value of a check box into the decision tree.
Anyone know how to do this properly?
Thanks, Rob