B
Bart
I have a cross tab query below:
Owners Group Total <1 Month >1 Month
Support A 2 2
Support B 1 1
I have 3 Owners namely "Support A", "Support B" and "Support C".
However "Support C" does not appear because there is no value for "<1 Month"
and
">1 Month" field. But I want to show all the " Owners Group" even the value
for "Support C" are "0" for "1< Month" and ">1 Month"
Here is the SQL:
TRANSFORM Val(Nz(Count(Computation.[Ref No]),0)) AS [CountOfRef No]
SELECT Computation.[Owners Group], Count(Computation.[Ref No]) AS [Total Of
Ref No]
FROM Computation
GROUP BY Computation.[Owners Group]
PIVOT Computation.NoOfMonth In ("<1 Month",">1 Month")
Owners Group Total <1 Month >1 Month
Support A 2 2
Support B 1 1
I have 3 Owners namely "Support A", "Support B" and "Support C".
However "Support C" does not appear because there is no value for "<1 Month"
and
">1 Month" field. But I want to show all the " Owners Group" even the value
for "Support C" are "0" for "1< Month" and ">1 Month"
Here is the SQL:
TRANSFORM Val(Nz(Count(Computation.[Ref No]),0)) AS [CountOfRef No]
SELECT Computation.[Owners Group], Count(Computation.[Ref No]) AS [Total Of
Ref No]
FROM Computation
GROUP BY Computation.[Owners Group]
PIVOT Computation.NoOfMonth In ("<1 Month",">1 Month")