B
Bryboy
I am linked to a SQL database and have a field which is a ENUM with the
options of 'm' or 'f'.
In a report I am trying to work with this in a formula, but receive an
error. It doesn't seem to be a string or number.
Do I need to convert it to some other type? Here is my formula with the
field name "gender".
=IIf([gender]="m", "Boys","Girls")
Returns Error
options of 'm' or 'f'.
In a report I am trying to work with this in a formula, but receive an
error. It doesn't seem to be a string or number.
Do I need to convert it to some other type? Here is my formula with the
field name "gender".
=IIf([gender]="m", "Boys","Girls")
Returns Error