Update all fields

[Priya]

I have a table with a field Month_name. There is only one
row which has the data filled for this field. How do I
update all the other rows with the data from this one row
for this field(Month_name).

I get an error message "Must be an updateable query for
the following SQL :

UPDATE Table1 SET Table1.[Month_name] = (select Month_name
from Table1 Where Month_name is not null)
WHERE (Table1.[Month_name]Is Null);

How else can I do this?

Thanks for any help
Priya

 

[Priya]

I am sorry My subject above is wrong-I would like to
update a field(ie.for all rows). Thanks

 

[Priya]

I could find out a solution...
UPDATE Table1 SET Table1.[Month_name] = DMax
("[Month_name]","[Table1]");

Hope this helps somebody else.

-----Original Message-----
I am sorry My subject above is wrong-I would like to
update a field(ie.for all rows). Thanks

-----Original Message-----
I have a table with a field Month_name. There is only one
row which has the data filled for this field. How do I
update all the other rows with the data from this one row
for this field(Month_name).

I get an error message "Must be an updateable query for
the following SQL :

UPDATE Table1 SET Table1.[Month_name] = (select Month_name
from Table1 Where Month_name is not null)
WHERE (Table1.[Month_name]Is Null);

How else can I do this?

Thanks for any help
Priya
.

.