R
Rob
Hi,
A simple question, but I cannot find an answer to it. Can I use a subquery
to generate the list in the IN predicate in a crosstab query in MS Access
2003?
eg.
TRANSFORM Count(qryTasksBySection.taskID) AS CountOftaskID
SELECT qryTasksBySection.positionTitle
FROM qryTasksBySection
GROUP BY qryTasksBySection.positionTitle
PIVOT qryTasksBySection.statusTitle IN (SELECT tblStatus.statusTitle
FROM tblStatus);
A simple question, but I cannot find an answer to it. Can I use a subquery
to generate the list in the IN predicate in a crosstab query in MS Access
2003?
eg.
TRANSFORM Count(qryTasksBySection.taskID) AS CountOftaskID
SELECT qryTasksBySection.positionTitle
FROM qryTasksBySection
GROUP BY qryTasksBySection.positionTitle
PIVOT qryTasksBySection.statusTitle IN (SELECT tblStatus.statusTitle
FROM tblStatus);