Multiple Values in Condinational Expression

[Peter]

Hi again all,

=IIf([Case Status]="Open" And "Review",[Today]-[Due]) is this correct?...i
want to return a value if Case Status is open or review...

Thanks again for a great place

 

[Peter]

well///it should retun the result of [Today]this is a date field =Date()
minus [Due] this is a due date field only if the case is "Open" or "Review...

IIF statement is IIF([your field]=whatever,what to do if true, what to do if
false) You are missing the what to do if false portion of the statement. So:
IIF([case status]="open" AND "review",[today]-[due],What?)

Hi again all,

=IIf([Case Status]="Open" And "Review",[Today]-[Due]) is this correct?...i
want to return a value if Case Status is open or review...

Thanks again for a great place

 

[Peter]

I appologize for my ignorent explenation ..i just realized that it must be
diffuclt underatanding...
the IIf condition is in the control source of a textbox that will display
the value of [Today] and [due] fields were [Today] is noting else but a
hidden textbox with the Date() value and [Due] is a textbox populated with a
date format...but only if the [Case Status] textbox includes "Open" or
"Review"..

well///it should retun the result of [Today]this is a date field =Date()
minus [Due] this is a due date field only if the case is "Open" or "Review...

IIF statement is IIF([your field]=whatever,what to do if true, what to do if
false) You are missing the what to do if false portion of the statement. So:
IIF([case status]="open" AND "review",[today]-[due],What?)

Hi again all,

=IIf([Case Status]="Open" And "Review",[Today]-[Due]) is this correct?...i
want to return a value if Case Status is open or review...

Thanks again for a great place

 

[golfinray]

IIF statement is IIF([your field]=whatever,what to do if true, what to do if
false) You are missing the what to do if false portion of the statement. So:
IIF([case status]="open" AND "review",[today]-[due],What?)