Update Query - Moving Data to Different Fields

K

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DSum update query with multiple fields 0
Update TableA with data from TableB using Update Query 3
Update Query - Move Data Between Fields 1
Moving multiple data to new fields 1
Use Update Query to Add Fields 1
update query 2
Append Query To Table 3
query to overcome field type problem? 4

Top