How to add a field to every record in a table with same data?

  • Thread starter Thread starter Craig Walker
  • Start date Start date
C

Craig Walker

I have a Table with lots of records. I forgot to add the a field with the
same name "Craig" to every record. Any ideas how to do this?
 
Add the field in the table's design view. Run an update query like:

UPDATE MyTable SET NewField = "Craig"
 
Back
Top