Hi all,
I need to build an expression that shows a 1 if the fields have changed (not if they are not both null or have if they both an empty space in them).
Meaning, if the fields are empty, I do not want the field to return a 1. I have the IIF statement, but can't figure out where to put the null or the "" parts.
Here is what I have so far:
Changed_Corp_Job_Y_N: IIf([1-b Monthly_Staffing].[Corporate Job Title]=[tbl_Select Current Month].[Corporate Job Title],0,1)
Thanks!
I need to build an expression that shows a 1 if the fields have changed (not if they are not both null or have if they both an empty space in them).
Meaning, if the fields are empty, I do not want the field to return a 1. I have the IIF statement, but can't figure out where to put the null or the "" parts.
Here is what I have so far:
Changed_Corp_Job_Y_N: IIf([1-b Monthly_Staffing].[Corporate Job Title]=[tbl_Select Current Month].[Corporate Job Title],0,1)
Thanks!