How do I insert a "2" into existing records in a blank column?

[carian]

I want to update a table by inserting identical data into the same field of
thousands of records, starting with a blank column. Find and Replace won't
work in this case, since I'm starting with nothing in the field. Is there
some relatively SIMPLE procedure like Find and Replace where I can paste the
same data into the same field of multiple records?

Thank you for kindly sharing your knowledge with a struggling neophyte.

 

[Brian Bastl]

Update MyTable Set MyField = 2 Where (((MyField) Is Null))

Change the names appropriately.

Brian

 

[John W. Vinson/MVP]

I want to update a table by inserting identical data into the same field of
thousands of records, starting with a blank column. Find and Replace
won't
work in this case, since I'm starting with nothing in the field. Is there
some relatively SIMPLE procedure like Find and Replace where I can paste
the
same data into the same field of multiple records?

Thank you for kindly sharing your knowledge with a struggling neophyte.

Create a new Query based on the table; use the Query menu option to change
it to an Update query; put 2 (or the value you want inserted) on the Update
To line under the field; add any criteria to limit which records are updated
(don't use any criteria if you want to update every record in the table);
and run it by clicking the ! icon.