Update Query - Move Data Between Fields

B

Big Dog

I have a table made up of fields A, B, and C. I want to update the data in
the table such that the value in fields C is placed in field A, and field C
is set to null. thanks for the help -seems like this should be very simple.
 
F

fredg

I have a table made up of fields A, B, and C. I want to update the data in
the table such that the value in fields C is placed in field A, and field C
is set to null. thanks for the help -seems like this should be very simple.
Click to expand...

Back up your table first.
Create an update query.

Update YourTable Set YourTable.[A] = YourTable.[C],YourTable.[C] =
Null
 
Top