Update a field in a table with a field in the same table

[Kou Vang]

This sounds pretty stupid, but I can't figure this out? Brain freeze!

 

[Kou Vang]

The question is how to: Update a field in a table with a field in the same
table

 

[[MVP] S.Clark]

Update Tablename (Field1) Values (Field2)

--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

 

[Duane Hookom]

It would have been nice if you would have taken the time to enter some
sample records with table and field names. However, you can try

UPDATE tblA
SET FieldA = FieldB;

 

[Kou Vang]

Update Tablename (Field1) Values (Field2)

Is this the SQL? Or what I put in the UPDATE condition?

 

[Duane Hookom]

Steve's SQL statement is most often used to update a single record. Is this
what you want to do? Did you try my suggestion?