Need help with this one guys. I have a calculated field called Classification: when date is null it calculates the word "UNCLASSIFIED" pretty straight forward but i cant quite get the syntax for 2 conditions.. Like if [Registered_date] is not null and [terminated_date] is null then calculate word CLASSIFIED.. Anything i try conflicts with the Unclassified expression
Heres my expression so far that works for Unclassified
Classification: (IIf(IsNull([Registered_date]),"UNCLASSIFIED") & IIf(Not IsNull([Terminated_date]),"UNCLASSIFIED"))
Heres my expression so far that works for Unclassified
Classification: (IIf(IsNull([Registered_date]),"UNCLASSIFIED") & IIf(Not IsNull([Terminated_date]),"UNCLASSIFIED"))