update same field - multiple values

[russi]

Hi.
Here's the scoop.
My database has numeric values for most fields. These values correspond to a prescribed data dictionary.
NOW, I must convert the values to other meanings/choices.
So that if '1' meant 'employee' and '2' meant 'student' and '3' meant 'retiree', then now '1' would mean 'retiree', '2' mean 'employee' and '3' mean 'student'.

How to update properly since after the 1st update i would not know which of the current '1's meant what?

Russ

 

[cpod]

You could run an update query and add 10 to your number field. Now, instead of 1,2,3, you have 11,12,13. Then you can update, say 11 to 2, 13 to 1 and 11 to 3.

 

[russi]

Thanks, CPOD.

Russ