I have 2 fields that need to be shown. Some of the records show the same data in both fields. I want to write an expression that will show both fields only if they don't have the same data.
Here is the direction I was going with it...but i'm an idiot and have no idea what I am doing:
Function FindLabel ( [field1] , [field2] ) Dim lbl lbl = [field1] If ( [field1] = [field2] ) lbl = lbl Else lbl = lbl & [field2] End If FindLabel = lbl End Function
Any simple solutions for this? Any help will be much appreciated.