Updating a field's data to another field in same table???

  • Thread starter Thread starter TotallyConfused
  • Start date Start date
T

TotallyConfused

I hope I make sense. What and how is the best way to update a field with
data from another field from the same table? Everything from Field 1 to
Field 2. Thank you in advance for any help you can provide.
 
I do not want to store a calculated field. I just want to copy what is in
one column to another column (field). I will then delete the first column.
Can this be done.? Thank you.
 
Use an Update query.

Update is on the Query menu, in table design.
Access adds an Update row to the grid.

To update Field2 with the value from Field1, type this into the Update row
under Field2:
[Field1]

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
 
Back
Top