Add one word to 500 records

D

Doug

I want to insert a new column into an existing 500 record table. I want to
enter the word “fullerton†into the new column. The word “fullerton†will be
inserted into each of the 500 records. Is there a way to automate this
process?
Thank you
 
A

Arvin Meyer

Doug said:
I want to insert a new column into an existing 500 record table. I want to
enter the word "fullerton" into the new column. The word "fullerton" will be
inserted into each of the 500 records. Is there a way to automate this
process?
Click to expand...

Write 2 queries, the first being a DDL (data Definition Language query):

Alter Table TableName Add Column ColumnName Text (10);

which will add a 10 character text column to your table. Then run an Update
query on your new column:

UPDATE TableName SET TableName.ColumnName = "fullerton";

Run both queries ... Done!
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top