I am looking for help with the syntax for 3 conditions in my query. Basically if [Date] is Null the calculated field called [Status] will be "NO" if [Date] between Date() and Date() +30 "EXP" and if [Date] >Date()+30 "YES"
Here's what I've done but can only get it to display the first condition "NO" on null fields
Status: (IIf([Expiry] Is Null,"NO") & IIf([expiry] Between Date() And Date()+30,"EXP" & IIf([expiry]>Date()+30,"YES")))
Any help appreciated
Here's what I've done but can only get it to display the first condition "NO" on null fields
Status: (IIf([Expiry] Is Null,"NO") & IIf([expiry] Between Date() And Date()+30,"EXP" & IIf([expiry]>Date()+30,"YES")))
Any help appreciated