Fixed column headings - using the IN predicate

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

MGFoster

Rob said:
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);
Click to expand...

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