Can't specify subquery in expression (Item).
Error 3203
The specified expression
Possible cause:
You used a SELECT Statement (SQL) 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, [Order ID], Sum([Sum2]) AS Expr1
FROM Orders
GROUP BY [Order ID]
PIVOT [Ship Name];
See Also
Using SQL (Structured Query Language)