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

On Sun, 14 Jan 2007 11:55:00 -0800, Andre
<(E-Mail Removed)> wrote:

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

UPDATE tablename SET columnname = '2007'

Andre wrote:

> 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

Uzytkownik "p" <(E-Mail Removed)> napisal w wiadomosci
news:(E-Mail Removed)...
> UPDATE tablename SET columnname = '2007'
>
> Andre wrote:
>
>> 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
>

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


"Jan Kowalski" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> Uzytkownik "p" <(E-Mail Removed)> napisal w wiadomosci
> news:(E-Mail Removed)...
>> UPDATE tablename SET columnname = '2007'
>>
>> Andre wrote:
>>
>>> 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
>>
>
>

Jan Kowalski wrote:
> Uzytkownik "p" <(E-Mail Removed)> napisal w wiadomosci
> news:(E-Mail Removed)...
>> UPDATE tablename SET columnname = '2007'
>>
>> Andre wrote:
>>
>>> 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

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.

--
Joseph Meehan

Dia 's Muire duit