iif not evaluating

  • 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
 
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...
 
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...
 
Back
Top