If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Field Form
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. |
Thread Tools | |
Display Modes | |
|
|