Update one field from another in the same table.

[lannoe]

This is probably a very basic question ...



I want to update an empty field with the value from another field. Can I use the Update Query? What would be my syntax?

Thank you for your help in advance.

Lori

[June7]

You can but why? Why duplicate data in table?

UPDATE tablename SET field2 = field1;

[lannoe]

Where do I type the code?

Because of the way our management software is set up. I need to update the one field and then we will delete the old field. We have to export the data from the software into Access to make this change.

[June7]

Okay, one-time occurrence. The UPDATE sql should populate the second field.

[lannoe]

I know it should but where do I type the code?

[June7]

Are you using query builder to create an UPDATE query object? Reference the old field in the Update To row under the new field.