iif wont evaluate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, can't understand why this wont work:
=IIf(Not [dtmDateClosed] Is Null,[dtmdateclosed],"On Order")
I should show the dtmdateclosed value if it isnt Null, and the Words "On
order" if not.

Todd
 
No Change.
It might be worth mentioning this is in a subform. Although the subform is
based on a query, and the field dtmDateClosed is a field in that query.

Todd

SusanV said:
Try:
=IIf(Not IsNull([dtmDateClosed]),[dtmdateclosed],"On Order")
--
hth,
SusanV


Access Idiot said:
Hi, can't understand why this wont work:
=IIf(Not [dtmDateClosed] Is Null,[dtmdateclosed],"On Order")
I should show the dtmdateclosed value if it isnt Null, and the Words "On
order" if not.

Todd
Click to expand...
Click to expand...
 
Access said:
Hi, can't understand why this wont work:
=IIf(Not [dtmDateClosed] Is Null,[dtmdateclosed],"On Order")
I should show the dtmdateclosed value if it isnt Null, and the Words "On
order" if not.
Click to expand...


"won't work" isn't very descriptive of what is happening.
However, I'll make a guess the problem is caused by the text
box being named the same as the field. If so, just change
the name to something else such as txtdtmDateClosed.
 
Back
Top