Fixed column headings - using the IN predicate

  • Thread starter Thread starter Rob
  • Start date Start date
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);
 
Back
Top