changing #'s in qry to words

[nydia]

I am trying to put together a query and i want the
person's name address, sex and other information. when I
run the query in the sex field it comes out a number,
1=male 2=female. how can i run the query so that instead
of 1 or 2 showing, it will show male or female??

i looked in the properties box for the form being used
and in the row source it has 1;"Male";2;"Female".

any help is greatly appreciated

 

[Jane]

Can you use the IIF function to display the gender in text
form?

 

[Duane Hookom]

Use the Choose() function.
Choose([Sex],"Male","Female")

 

[Denny G.]

Enter the the expression exactly as shown below in a new
column in your query:

Sex2: IIf([Sex]=1,"Male","Female")

There are other ways to fix this but for now, use above.

Sounds as though you are using a combobox to select the
sex. If so, choose the column that enters the actual
words "Male" and "Female", not 1 and 2.

Denny G.