Need query for table update. Newbie

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 6,000 records in Table A with field 1 and field 2. I want the data in
field 1 inserted into field 2 in Table A. I'm assuming I can use either a
append or update query. Am I right? How do I accomplish this? I need specific
instructions.
Thank you.
 
Thank you Lynn. That's what I needed. The reason is that field 1 was a combo
box set to a value list and I wanted to give the users the ability to add
values as needed. Field 2 data is a lookup field.
I plan to delete field 1 after the update.
Thanks again.

Lynn Trapp said:
An Update query would be what you need.

UPDATE [Table A]
SET [Field2] = [Field1];

I'm not sure why you want to do this, however. There is seldom, if ever, a
reason to have the same values in 2 fields in one table.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html



Me said:
I have 6,000 records in Table A with field 1 and field 2. I want the data
in
field 1 inserted into field 2 in Table A. I'm assuming I can use either a
append or update query. Am I right? How do I accomplish this? I need
specific
instructions.
Thank you.
Click to expand...
Click to expand...
 
You are welcome. I'm glad it helped.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html



Me said:
Thank you Lynn. That's what I needed. The reason is that field 1 was a
combo
box set to a value list and I wanted to give the users the ability to add
values as needed. Field 2 data is a lookup field.
I plan to delete field 1 after the update.
Thanks again.

Lynn Trapp said:
An Update query would be what you need.

UPDATE [Table A]
SET [Field2] = [Field1];

I'm not sure why you want to do this, however. There is seldom, if ever,
a
reason to have the same values in 2 fields in one table.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html



Me said:
I have 6,000 records in Table A with field 1 and field 2. I want the
data
in
field 1 inserted into field 2 in Table A. I'm assuming I can use either
a
append or update query. Am I right? How do I accomplish this? I need
specific
instructions.
Thank you.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top