Copying field value to multiple records in same table

  • Thread starter Thread starter John MacFall
  • Start date Start date
J

John MacFall

I have an Access 2007 table with multiple records already created. I want to
write the same value into the same field in each record. Is there a way to do
that all at once or do I have to peck my way down the column containing the
field one record at a time?
 
Use an update query. The SQL for such a query would look like:

UPDATE [YourTable]
SET [YourField] = "SomeSpecificValue"

In query design view
== Add your table
== Add the field to be changed
== Select Query: Update
== Run the query

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top