iif not evaluating

[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

 

[Amy Blankenship]

Try

IIF(IsNull([dtmdateclosed]), "On Order", [dtmdateclosed])

 

[Duane Hookom]

Please don't ask the same question in multiple news groups.

--
Duane Hookom
MS Access MVP

Try

IIF(IsNull([dtmdateclosed]), "On Order", [dtmdateclosed])

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

 

[Amy Blankenship]

There's me told

Please don't ask the same question in multiple news groups.

--
Duane Hookom
MS Access MVP

Try

IIF(IsNull([dtmdateclosed]), "On Order", [dtmdateclosed])

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