Is it possible to use a crosstab quey as a subquery?

[selahlynch]

Question...


Is it possible to use a crosstab query as a subquery?

I'm trying to do the following:

SELECT * FROM 
(TRANSFORM Max(Expirations.DateRequired) AS MaxOfDateRequired
SELECT Expirations.EmpID
FROM Expirations
GROUP BY Expirations.EmpID
PIVOT Expirations.EventID) as Xtab

But I get an error "Syntax error in FROM clause."