fill each record with same field entry after records already exist

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

Guest

How would I apply a given value to a newly created field of an existing table
with existing records. The value would be the same for all records.

I understand that for all new records I can simply set the default value in
design view to the desired value but I do not know how to automatically apply
this value to existing records.
 
Susan said:
How would I apply a given value to a newly created field of an existing table
with existing records. The value would be the same for all records.

I understand that for all new records I can simply set the default value in
design view to the desired value but I do not know how to automatically apply
this value to existing records.
Click to expand...

Use an Update query.

UPDATE TableName
SET FieldName = Value
 
Back
Top