I am trying to write an expressions using the IIF function such that the results will yeild me either "Open", "Lost", or "Awarded" as the response. Each response must follow the following criteria:
"OPEN" = [Date_Approved]=Null AND [Date_Closed]=NULL
"LOST" = [Date_Approved]=Null AND [Date_Closed]<>NULL
"Awarded" = [Date_Approved]<>NULL
If the Date Approved is Null then it depends on whether or not the Date Closed is NULL or not to determine "OPEN" or "LOST".
Can this be written into 1 IIF function to yield the three possible results based on the criteria set forth?
Thank you for your help.
"OPEN" = [Date_Approved]=Null AND [Date_Closed]=NULL
"LOST" = [Date_Approved]=Null AND [Date_Closed]<>NULL
"Awarded" = [Date_Approved]<>NULL
If the Date Approved is Null then it depends on whether or not the Date Closed is NULL or not to determine "OPEN" or "LOST".
Can this be written into 1 IIF function to yield the three possible results based on the criteria set forth?
Thank you for your help.