I want to set up a label to update dynamically..I can use either a Case Statement or an IFF, But I am not sure exactly how to do it..
For example, I have 4 employees, Mary, Tom, Pete, Gordon,,HOW do I set the IFF function, that when Mary is selected, it updates that Mary is Female, Pete is Male and so forth.
or any good Links I can follow.
Thanks in advance.