i am new to access, sql and vba access.
access table (Table1) has
ID Gender NewGender
1 male -
2 female -
3 males -
etc
I want the field Table1.NewGender to be populated with numerical codes 1 and 2 for males and females respectively based on Table1.Gender field.
My visual basic editor has this:
Sub recode()
End Sub
Could you pls start me off by giving me the VBA code i need to do this recoding that i can paste into the editor between sub recode and end sub
Thankyou