Update table not working

[newtoAccess]

As per my previous problem update Query being too large. It worked great and did what I wanted until Iran out of space.



Now I have 2 select queries. That count, sum and calculate percent. The select query results work good.

How should I get them into my 1 table?
Use update query?
I created a new update query to update from query Part1 to the table and nothing is found. I am asked to enter anything I want for each field.

The help file does not explain what should be in the windows.

The top half of the window shows the destination table.

In the bottom half I have selected the field, the table, in the update to box I have the source [query Name]![query field]


The result is: I am asked to enter what I want for each field and still nothing shows up in my table.

So what am I doing wrong?
----------------------------------

UPDATE Table_Sum_All SET Table_Sum_All.CountOfID = [Query_Make_Table_Sum_All_Part 1]![CountOfID], Table_Sum_All.CountOfAge = [Query_Make_Table_Sum_All_Part 1]![CountOfAge], Table_Sum_All.SumOfAge15 = [Query_Make_Table_Sum_All_Part 1]![SumOfAge15], Table_Sum_All.Age15Percent = [Query_Make_Table_Sum_All_Part 1]![Age15Percent];

[newtoAccess]

I ended up making 2 make table queries.
and I will see what will happen then