I have a query with the "Switch' function that looks like this
Works great. I now want to add the OR IS NULL into the mix and I am not sure how to do it correct. So I want it to say logically
If Date1 is before 1/1/07 or is null then fail OR if Date 2 is before 1/1/07 or is null then fail.
Can someone help? thanks.
Code:
PASS: Switch([Date1]<#1/1/2007# Or [Date2]<#1/1/2007#,'FAIL')Works great. I now want to add the OR IS NULL into the mix and I am not sure how to do it correct. So I want it to say logically
If Date1 is before 1/1/07 or is null then fail OR if Date 2 is before 1/1/07 or is null then fail.
Can someone help? thanks.
