If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Add one word to 500 records
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 -- Doug |
#2
|
|||
|
|||
"Doug" wrote in message
... 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? 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Gripe about Word and image placement | Harlan Messinger | Page Layout | 31 | September 13th, 2004 04:16 PM |
find and replace | ladyinred | General Discussion | 14 | August 12th, 2004 09:35 PM |
Finding and deleting repeated records in WORD Document. | Richard | General Discussion | 1 | May 23rd, 2004 02:01 AM |
Codes | G.W. | Page Layout | 3 | April 29th, 2004 10:50 PM |
Word 2003 is adding duplicate records to my mail merge | Doug Robbins - Word MVP | Mailmerge | 0 | April 24th, 2004 03:58 AM |