IIF Help

[brin]

In the query i have i wish to do the following:

I have two columns:

Column A
Yes
Yes
Yes
No
No

Column B(date field)
DATE
DATE
DATE

I would like to code a script where:

if column A was "YES" and column B had a "DATE", then output "****", and

if column A was No and Column B was null then output"****".

If column A was yes and column B was not null then out put column B.

Please help.

 

[dcx693]

Sounds like the ony time you want to output column B is if column A was yes and column B was not null:

IIf([ColumnA]="yes" And IsNull([ColumnB]),[ColumnB],"****")