insert into many rows

[fguihen]

i have a table with about 40 columns in access 97( terrible i knw, but
its not mine and im not allowed normalize or change it) . i have added
a column , which is a number , called year. it will contain 1997,
1998, etc. there are about 1600 rows in the table. is there anything
like a correlated sub query that will allow me to insert this into the
date column of each row??

[Simon Hayes]

"fguihen" <sc*******@yahoo.co.uk> wrote in message
news:ad**************************@posting.google.c om...

i have a table with about 40 columns in access 97( terrible i knw, but
its not mine and im not allowed normalize or change it) . i have added
a column , which is a number , called year. it will contain 1997,
1998, etc. there are about 1600 rows in the table. is there anything
like a correlated sub query that will allow me to insert this into the
date column of each row??

Since this seems to be an Access question, you will probably get a better
answer in an Access newsgroup.

Simon

[John Bell]

Hi

You desciption is not clear as to what you really want. At a guess you are
thinking about a derived table such as

SELECT * FROM
( SELECT 1997 as Year, Col1, Col2, Col3
FROM X ) X

There is no indication how you create the year so if it is dependent on
other columns then

SELECT * FROM
( SELECT CASE Col1 = 'A' THEN 1997 ELSE 1998 END as Year, Col1, Col2, Col3
FROM X ) X

In access you could create a query instead of the derived table and select
from that, instead of using CASE use IIF.
John

"fguihen" <sc*******@yahoo.co.uk> wrote in message
news:ad**************************@posting.google.c om...

i have a table with about 40 columns in access 97( terrible i knw, but
its not mine and im not allowed normalize or change it) . i have added
a column , which is a number , called year. it will contain 1997,
1998, etc. there are about 1600 rows in the table. is there anything
like a correlated sub query that will allow me to insert this into the
date column of each row??