Recent content by bdewilde

I'm linked to a SQL database with field "gender' type ENUM with options "m","f","b". On a report I want to change the "m" to "Boys", etc. I tried =IIF([gender]="m", "Boys", "Girls") This returns an error. I tried equal to 1 and 0 also to but Access doesn't seem to see it as a number or...