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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

iif wont evaluate 3
Calculating Days for Order Turnaround. 4
Calculating Days on Order, formula wont work with Text Values 1
Date / time Field with a null value 1
Word VBA (probably) conditional paragraph spacing based on preceding paragraph style 0
Using Min Function within DLookup Function 0
Multiple iif challenge 2
Merging from an Excel file with graphics 1

Top