iif not evaluating

A

Access Idiot

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
 
D

Duane Hookom

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

--
Duane Hookom
MS Access MVP


Amy Blankenship said:
Try

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


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...
 
A

Amy Blankenship

There's me told :)

Duane Hookom said:
Please don't ask the same question in multiple news groups.

--
Duane Hookom
MS Access MVP


Amy Blankenship said:
Try

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


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...
Click to expand...
 
Top