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"
 

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

Calculated field in a table 6
DELETE FROM a table WHERE... 1
I want access to fill a field with the current date 4
Search utility 2
Access Dcount (multiple criteria) 3
How to export table from outlook into ms access table? 0
one record 10 fields to ten rcords 1 field 6
Query design 0

Back
Top