selahlynch
Registered User.
- Local time
- Today, 14:30
- Joined
- Jan 3, 2010
- Messages
- 63
Hello,
Is it possible to use a crosstab query as a subquery?
I'm trying to do the following:
But I get an error "Syntax error in FROM clause."
And in case you are curious... I'm trying to do this so that I can use the query as the record source for a subform within a form. Choices on the form affect the query.
Is it possible to use a crosstab query as a subquery?
I'm trying to do the following:
Code:
SELECT * FROM
(TRANSFORM Max(Expirations.DateRequired) AS MaxOfDateRequired
SELECT Expirations.EmpID
FROM Expirations
GROUP BY Expirations.EmpID
PIVOT Expirations.EventID) as Xtab
And in case you are curious... I'm trying to do this so that I can use the query as the record source for a subform within a form. Choices on the form affect the query.