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

Similar Threads

Nested IF conditions 3
DMax on existing record to increment serialized # fails 1
Concatenate Checkbox 4
Prompt for input if another field is not blank 5
Make a Field Visible based on data in 2 other feilds 5
Access Building a IIF expression in Access 0
IIf Statement returns Text when null 1
Option Group ListBox Row Source "Expected end of statement" 0

Back
Top