Creating a new modified table with existing table

[reena]

Hi,

I have a table with Individual_Id and Membeship as their fields. The Membership field basically has couple of "yes" or "no"s, I want to code in such a way, so that where ever there is a "yes" in membership field, it has to replace to 1
and "no" to 2 and put the whole data in different table.

I am new to programming.
Please help me with this. I am going nuts.
Thanks a lot
Regards

 

[Rich]

Why do you need to change yes/no to 1 or 2? Please explain a little more on what you are trying to achieve. Update and append queries seem the obvious answer.
HTH

 

[reena]

Hi Rich

Thanks for your reply. Actually I am trying to import the data from a old database into new database.
Priorly in the old database in table Individual information
has a field called member to show a whether the individual is member or non-member to a company, and has data in form of 'yes' and 'no' in the text field.

'yes' if member
'no' if nonmember.
Now in the newly constructed database.
I have the user to select the member of nonmember option with a dropdown box. so I have them in a separate table.
With Individual_ID and membership fields.

I should transfer the data accordingly.
If the field data in old database has 'yes' under member field than in teh new table it should be transported as 1 under membership field.
If 'no' then 2 as data in membership field in old database.

Hope I made it clear.

Tahnks a lot.

Regards