Discussion Locked

IIf this than this?

0 helpful

4 replies

by natasha.epperson Mar 30, 2005 last reply Mar 31, 2005

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

My Origional formula for my report was this:

=IIf([AfterFact]="1","Y","N")

However I need to tell the field that if it's 1 or 2 = Y, Null or 3 = N

4 replies

Try this.
IIf([AfterFact]="1" Or [AfterFact]="2","Y",IIf([AfterFact]="3" Or IsNull([AfterFact]),"N","Other Value"))

Poster rated this answer.

hehe, kept playing around....
This is what I came up with that worked.
=IIf([AfterFact]="1" Or [AfterFact]="2","Y","N")

This question was closed by the author

This discussion is closed to new replies.