SQL ENUM data type (1 Viewer)

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 text.

How do I deal with this data type?

Bryan

I'd avoid ENUM and use a simple lookup table as this is easier to support across ODBC. ENUM is a MySQL extension to the SQL standard which ODBC does not know about and therefore cannot translate correctly.