Copy data to new field across alll records...?

  • Thread starter Thread starter dca_tech
  • Start date Start date
D

dca_tech

I need to create a new field in a table, and I would like to insert a
value in the new field across all existing records.

Example: Table A (250 records) has 3 fields = Name, Address, Phone

Created new field "City" and would like to insert the value "Chicago"
across all of the existing 250 records.

Any information is gratly appreciated.
 
After adding the field to your table, use an Update query to populate it.

1. Create a query into the table, and drag the City field into the grid.

2. Change it to an Update query (Update on Query menu).
Access adds an Update row to the grid.

3. In the Update row under City, enter:
"Chicago"

4. Run the query.

No need to save the query.
 
This is easily accomplished with an update query. Start with a Select query (this is the
default query type). Add the City field to this query. If you are going to update all
records, you don't need to include any criteria to filter the recordset. Convert the
query to an update query. In query design, click on Query > Update Query. You should see
a new row in the QBE grid that reads "Update to:". Enter "Chicago" and run your query.

HOW TO: Convert a Select Query to an Action Query in Access
http://support.microsoft.com/?id=304354

Tom
____________________________________


I need to create a new field in a table, and I would like to insert a
value in the new field across all existing records.

Example: Table A (250 records) has 3 fields = Name, Address, Phone

Created new field "City" and would like to insert the value "Chicago"
across all of the existing 250 records.

Any information is gratly appreciated.
 
Back
Top