Can't specify subquery in expression (Item).

Error 3203

The specified expression1DUM8 contains a subquery or other expression that functions as a subquery.

Possible cause:

          You used a SELECT Statement (SQL)ZUPF0W 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)2WCWZZP