Subqueries cannot be used in the expression <expression>. (Error 3203)
The specified expression contains a subquery or other expression that functions as a subquery.
Possible cause:
You used a SELECT statement that includes an aggregate function that evaluates another aggregate function. This error occurs, for example, if you execute the following statement:
TRANSFORM Sum([OrderAmount]) AS Sum1
SELECT Sum([Sum1]) AS Sum2, OrderID, Sum([Sum2]) AS Expr1
FROM Orders
GROUP BY OrderID
PIVOT ShipName;
Sum([Sum2])
Sum([Sum1])