Cannot Update a table from a Query field based on a sum and grouped field..

[Will]

I made a query called Size_GIS_SUM which is a sum of land areas by project name.

I want to use this query to update to another table called t2 where a separate field called project_land_size will show the value based on the sum of each projects land areas.

Problem is I keep getting weird errors.
My statement is
T2 = the project able with the summed the empty field for project summed values.


Size_GIS_SUM is the query which is based on the summing of another table and grouped by project name.

**** SQL statement

UPDATE T2
INNER JOIN Size_GIS_SUM ON T2.[Extended Project Name]=Size_GIS_Sum.[Extended_Project_Name]
SET T2.[Size] = Size_GIS_SUM.[SumOfSize_GIS_3];

Is it not possible to update a table from a query based on sums or that are grouped ?

[RuralGuy]

This link should answer some of your questions about non-updateable queries: http://allenbrowne.com/ser-61.html