Hello,

I have an option group on a form that users select tween two choices. The
form says "Male" and "Female", but the values stored in the table are "1"
and "2". In my queries and reports, how can I get the values to show as
"Male" and "Female" again?

Many thanks,

Ripper

--
Ripper T Smith
rippertsmith<nospam>@comcast.net

> Hello,
>
> I have an option group on a form that users select tween two choices.
> The form says "Male" and "Female", but the values stored in the table
> are "1" and "2". In my queries and reports, how can I get the values
> to show as "Male" and "Female" again?
>
> Many thanks,
>
> Ripper

=Choose([FieldName], "Male", "Female")

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com