Copying field value to multiple records in same table

[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?

 

[John Spencer]

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