From: ghetto_banjo on 11 May 2010 15:06
Well, I believe Option Groups always store numeric values like that,
so there are 2 choices that come to mind.
In your query (or report), use nested if statements like:
if([gender] = 1, "Male", if([gender] = 2 "female", "trans"))
Or you could create a table with 2 fields that has the relationship of
Numeric Values and Genders and then link to that table in the query.
From: ghetto_banjo on 12 May 2010 09:46
you could put it right in a TextBox on the report.