Autofill Column

[Guest]

Hi,

I am new at access and I am trying to add a column that shows the same
number in each row. IE. The year 2007 all the way down the column. Is
there any way to automate this as I have many rows 20,000+. As of now I am
copy and pasting from excel but this is annoying.

Thanks

 

[John Vinson]

Hi,

I am new at access and I am trying to add a column that shows the same
number in each row. IE. The year 2007 all the way down the column. Is
there any way to automate this as I have many rows 20,000+. As of now I am
copy and pasting from excel but this is annoying.

Thanks

You can run an Update query to update the table... but I'm not sure I
understand. Do you have 20000 already existing records with a NULL in
this field? Or are you creating empty "placeholder" records to be
filled in later (if so, DON'T; instead just set the DefaultValue
property of the field to 2007)? What's the structure of your table?

John W. Vinson[MVP]

 

[p]

UPDATE tablename SET columnname = '2007'

 

[Jan Kowalski]

UPDATE tablename SET columnname = '2007'

 

[Tom Ventouris]

Create and Update Query to update the field.
The simplest way is to create it in design view.

 

[Joseph Meehan]

On the chance that you may always want 2007 in every row, you should not
add it to the table at all, but you should add it on the form or report and
not save it in every record. Repetitive data should normally not be saved in
each record as you are forced to do in a traditional spreadsheet.