B
Biggles
Can I put a where clause on a cross tab? The following doesn't restrict any
items that are tabulated:
TRANSFORM Count(qryALLISSUES_BASE.[Issue Reference Number]) AS [CountOfIssue
Reference Number]
SELECT qryALLISSUES_BASE.[Classification Code Name],
Count(qryALLISSUES_BASE.[Issue Reference Number]) AS [Total Of Issue
Reference Number]
FROM qryALLISSUES_BASE
WHERE (((qryALLISSUES_BASE.[Classification Code Name])<>"") AND
((qryALLISSUES_BASE.[Issue Status Name])="open") AND
((qryALLISSUES_BASE.txtISSUE_TYPE)<3)) OR (((qryALLISSUES_BASE.txtISSUE_TYPE)
Is Null))
GROUP BY qryALLISSUES_BASE.[Classification Code Name]
PIVOT qryALLISSUES_BASE.[Audit Group Name];
Do I have to create a new query to exclude the proper items?
items that are tabulated:
TRANSFORM Count(qryALLISSUES_BASE.[Issue Reference Number]) AS [CountOfIssue
Reference Number]
SELECT qryALLISSUES_BASE.[Classification Code Name],
Count(qryALLISSUES_BASE.[Issue Reference Number]) AS [Total Of Issue
Reference Number]
FROM qryALLISSUES_BASE
WHERE (((qryALLISSUES_BASE.[Classification Code Name])<>"") AND
((qryALLISSUES_BASE.[Issue Status Name])="open") AND
((qryALLISSUES_BASE.txtISSUE_TYPE)<3)) OR (((qryALLISSUES_BASE.txtISSUE_TYPE)
Is Null))
GROUP BY qryALLISSUES_BASE.[Classification Code Name]
PIVOT qryALLISSUES_BASE.[Audit Group Name];
Do I have to create a new query to exclude the proper items?