Jet database engine does not recognize... ?

[G Lykos]

Understand this is a problem typically related to Access pivot-table
queries. Am not sure why I'm running into it or how to resolve it.

Situation: Have a pivot-table query. The results are read into a standard
SELECT query, Summary Closed. A third SELECT query is then used to read
that standard SELECT query with the intention of generating a running total.

The third query in reduced form (meaning I'm backtracking, trying to get
something working right) is simply:
SELECT [Summary Closed].*
FROM [Summary Closed];

No problem - it regurgitates Summary Closed, a SELECT query.

To reach full form with a running total, I then insert a subquery:
SELECT [Summary Closed].*,
(SELECT [SUM ([Total Closed]) FROM [Summary Closed] AS X
WHERE X.[Week Ending] <= [Summary Closed].[Week Ending]) AS
Total
FROM [Summary Closed];

Resulting Access error message: "The Microsoft Jet database engine does not
recognize '[Summary Close].[Week Ending]' as a valid field name or
expression."

The exact same query / subquery running-total syntax works just fine on a
data table (rather than a query).

I see various mentions on-line of needed to explicitly name and typecast a
Parameter in the pivot-table query. Not sure how that might enter here
given that the pivot-table query is twice removed from the query / subquery
giving the problem.

Thanks in advance for any ideas.

George