I'm not sure what it is exactly that you are trying to achieve, but I'm almost certain that you're trying to do two things in one shot, which cannot be done.
Your query that works returns a table with one record for each value of "new_row". If you would execute the second part of you original query, you would get a table with one record, a kind of an aggregate value, let's call that S. That's kind of contradictory no?
If what you are trying to achieve is a table with an entry for each row and in each row the result of the second part (what we called S), then you might will need 1) to execute your query that works and create a table, 2) execute the second to get S and then and 3) an update query that copies S in each record of the table you created in 1).
Tell us more about your environment (VBA, or just plain Access?), then we can show you code.