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 ?