Hi,

I'm trying to update a row in a table. The value in this record must
be set to the sum of a column from another table. I can't seem to figure
this out, i keeps saying my query is not updateable. Any sugguestions.
Thanks in advance.

TIA

Hi:
My guess is that you are trying to do this in one query.
You need 2.
Query A is the sumation query. Assume that the column you want is
named SumOfX.
Then query B is your update query.
There needs to be a link between the 2 queries.
You then update the column you need in B with SumOfX.

Good luck
Ira Solomon

On Wed, 19 Jan 2005 22:22:16 -0600, someguy <inderjitrai (AT) yahoo (DOT) com>
wrote: