Autofill Column

A

Andre

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
 
J

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
Click to expand...

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]
 
T

Tom Ventouris

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