Update Query - Moving Data to Different Fields

[Karen]

I have a field that was returned to me from the State that now has multiple
records for each person. Each person in my primary table has an ID that is
the Primary key. I need to merge this new data with my current data
maintaing my Primary Key field. The fields are:

Program_Type
Program_Type_Code

I have assigned each of them that have more than one Tye and Type Code a
letter of A, B, C or D so that they can go into their own fields of:

Program_Type1
Program_Type_Code1

Program_Type2
Program_Type_Code2

etc.

I need to know how to set up the update qry to get the data out of
Progarm_Type1 and into Program_Type2 if the letter code is "B" or
Program_Type3 if the letter code is "C", etc.

Thank you in advance for your help. The fields have already been added to
my table. I have already tried the on-line help, but it did not help me out
any.

 

[Karen]

Never mind, I figured it out. Thanks anyway.