Update Query - Move Data Between Fields

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

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split data in field on character return 0
Dcount returning no results!!! 0
Update query. Within the same table: populating field 2 from field 6
Appending null data and moving! 4
update two fields at once 1
Query field names 2
Help with expression builder in a select Query 2
Query on two tables with matching null fields 4

Back
Top