changing #'s in qry to words

  • Thread starter Thread starter nydia
  • Start date Start date
N

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
 
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.
 
Back
Top