Nested IF statements

  • Thread starter Thread starter StephanieH
  • Start date Start date
S

StephanieH

The following formula almost meets my needs. What I need is
if SCI1 is null, then null
if SCI1 is not null, then if SCI1 is before 1/7/08 then "Y", if SCI1 is not
before 1/7/08 then "N"

=IIf([SCI1]<>"" And ([SCI1]<="1/7/2008"),"Y","N")

How do I add that if it is null, leave this field blank?
 
IIf([TableName]![SCI1]<#01/07/2008#,"Y",IIf([TableName]![SCI1]>=#01/07/2008#,"N",Null))
 
Back
Top