Condition or criteria in a query

[Khalil Handal]

Hi to all,


I have a query based on different tables. One of the fields have a value of 1 or 2 . I want to add a new calculated field to the query were the 1 is replaced with Male and the 2 is replaced with Female.
Is this possible?

Khalil

[ranman256]

join tGender table to your query,
contents:
Code, Gender
1, Male
2,Female

join tGenter.Code on the numeric column of your other table,
bring down tGender.Gender field into the query results.

[Khalil Handal]

Thank you for the reply.
Khalil