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
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
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.
Thank you for the reply.
Khalil