Extract data from one field and put in another

[redclaygirl]

I am trying to extract data from one field and then put it into another field. I have 2 fields, Code_A and Code_B. I am trying to take the Code * data from Code_A and put it in Code_B. Any help is appreciated.

Code_A Code_B
Alpha Code 3
Code 3
Alpha Code 3
Code 2
Delta Code 3
Code 3 Unknown
Charlie Code 3
Code 3

 

[mresann]

Assuming table name of tblCode, use the following query:

UPDATE tblCode SET tblCode.Code_B = tblCode.Code_A, tblCode .Code_A= Null;

 

[redclaygirl]

Thank you so much for your help. However, I am in the beginning stages with Access and not sure about the tblcode stuff. Are you saying that I start with an update query and then plug in the tblCode SET tblCode.Code_B = tblCode.Code_A, tblCode .Code_A= Null; part in my Code_B field criteria? I am not sure what tblCode refers to. I apologize for my ignorance. Any clarification would be welcome. I appreciate your time.

 

[mresann]

OK, I was going by the assumption that you have the following:
1. A table called tblCode
2. Fields in tblCode that are called Code_A and Code_B
3. A requirement to transfer data from Field Code_A to Field Code_B

Indeed, you see that it is an update query that I have posted. Now, I don't know the actual name of YOUR table, so I called it tblCode.

If you are truly in the beginning stages with Access, you may wish to go to the Microsoft site and go through one of their many tutorials for beginners. Spending two or three hours through those tutorials should give you a base understanding of table structure, field names, datatypes, and beginning queries.

 

[redclaygirl]

thank you. no worries.