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

[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.

 

[Allen Browne]

See:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

The article describes how - and, more importantly, when - to store a field
that depends on another field.

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

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

message
news:[email protected]...

 

[TotallyConfused]

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.

 

[Allen Browne]

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