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

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

Back
Top