This is probably a simple solution for you guys.
I am trying to create a binomial category of a Customer ID.
Basically if Customer ID has no value or NULL = '0' and if Customer ID EXISTS then = '1'.
Do you guys advise an IF THEN or Case statement?
Thanks for your help.
Try using this: IIF(ISNULL([Customer ID]),0,1)