I am trying to do simple IIF expression but for some reason it is giving me an #error I am doing =IIF [Error_Type]="error1", Analyst_Comment, " ")
Basically I believe this means that if there is an error within the Error_Type field name called Error1 it will show the comments if not it will be blank but it is giving me an error and I dont know why? it says its a circular reference or invalid control property?
Many thanks for any help on this.