Fixed column headings - using the IN predicate

[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);

 

[Duane Hookom]

No.

 

[MGFoster]

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);

Interesting question. Why don't you just run the query & find out?