Hi all,
I have a field in my query that is 1,2 or 3 from an option group. I want to display either Male, Female, or Unknow on my form.
This is what i was using but i get an error when opening query.
"Unidentified Function "If" in Expression"
Gender1: If([Gender]="1","Male",IIf([Gender]="2","Female","Unknown"))
What am i doing wrong?
Thanks