How to add a column to an existing table and fill it (i.e., filldown) with a particular word / numbe

[Mike C]

Hello - I have a basic question.

How do I add a new column to an existing table, and place a word in it
so that it repeats all the way down the column?

Thanks.

 

[Wayne-I-M]

Hi Mike

What is the point of doing this. If you have a million records you will
have a million repetitions of the same text string.

If you "really" don't want to add the word as and when needed (very simple
in a query report or form) you could use an update querry (if the word may
change) or just add a default to the table field which will allow overwritting

But again there seems to be no point in this

 

[Jim Bunton]

Create the column with table > design

then create the query Update mytable.columnName set mynNwRow = "whatever"

 

[Jim Bunton]

err - oops - well the query's something more like

Update myTable SET myNewColumnName = "Whatever"

you can create it in the query generator -perhaps bet to try it on a copy of
the table first!!!

 

[viktor chuzhakin]

Hello - I have a basic question.

How do I add a new column to an existing table, and place a word in it
so that it repeats all the way down the column?

Thanks.