I have seen this expression in several places.
Would someone please explain the theory of operation.
The reason I ask is that when I recreate this same expression in the "Expression Builder", the tool tips that are displays as I am typing just doesn't make sense.
Thanks,
-Kyp
Would someone please explain the theory of operation.
File As: IIf(IsNull([Last Name]);IIf(IsNull([First Name]);[Company];[First Name]);IIf(IsNull([First Name]);[Last Name];[Last Name] & ", " & [First Name]))
The reason I ask is that when I recreate this same expression in the "Expression Builder", the tool tips that are displays as I am typing just doesn't make sense.
Thanks,
-Kyp