how to recode from text to number in access

[Guest]

I have a data field 'Gender' and it has male and female as the variables. i
want to convert them into numerical codes i.e. male = 1, female = 2, in
access. How do I go about it?

Gabriel

 

[Van T. Dinh]

* Create a new Field NewGender of numeric data type (of Byte size).
* Use an Update Query to assign value 1 or 2 to this Field for each Record
depending on the value of the Field Gender.
*Once the update is done and checked OK, delete the old Field Gender and
rename the Field NewGender to Gender.